Copy Data From File1 to File2

[simonstaton]

Hi,

I am trying to have an excel sheet link to another excel sheet. one sheet is where we decide all our pricing and the second sheet is a websites prices.

for example sheet one:
Reference Price
A110 100
a440 200

sheet two:
Reference Price
a440 220
A110 98

I want it so that when you change the price of "A110" on sheet one it changes the price of "A110" on sheet two. I have achieved this using the following formula:

Please Login or Register  to view this content.

however when you add another column to sheet 1 unless you have sheet 2 open things start to mess up.

So can I have sheet two look in sheet 1 by reference and find that exact product then shift along to the next column and grab the price?

Thanks,
Simon

[simonstaton]

Any ideas? I am deseperate!