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...