This might not be too difficult but I can't crack it.
I have two worksheets. One stores pricing data with various forumlae calculating prices at different percentages etc. The other is a summary sheet where I have the final prices showing for easy reference.
At the moment I have to copy the values across using the special paste values option. However, the two sheets remain separate and must be updated separately.
I would like to be able to connect the two so that when on the first sheet a price is updated and the values calculated, the updated final price appears on the second worksheet.
Possible?
Thanks.


LinkBack URL
About LinkBacks
Reply With Quote




