What is the best way to get source documents updated after changing values in Vlookup tables? Usually, I end up copying the formula from a nearby cell to the cells that are not updating (prices, in this case), but I know there's got to be an easier way... (Yes, my calculation is set to automatic). I have a lot of price changes - if I have to copy the formula to each cell in the source document that should be changing, I may as well just scrap the Vlookup...
Thanks for any advice you may have...
Don't understand: changes to VLOOKUP table data should not require changes to formulae.
Post a small sample file (not image) illustrating your requirement.
To upload a file click "Go Advanced" then scroll down to "Manage Attachments"
Agreed that your description is not clear
What is changing?
If the vlookup - why>?
If the source data, why would you need to change the formula?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks