Migrating linked cell data without losing calculations

Hi,

I have inherited some legacy excel sheets which I’d like to fix. I have two linked sheets. Several cells in my main file read from a “feeder file”, the feeder file is where I obtain original data and convert it to an appropriate unit. I then link to the feeder file.

I want to be able to migrate the data from the feeder file to my main file. But I also want to see the calculations/conversions from the feeder file in the main file and not as values. Basically I want the data input from the feeder file to the main file. I have several years worth of data, so going about it manually will be inefficient.

I am attaching a worksheet as an example. Here, I have ethanol consumption data in the feeder file for a few months in the year 2008. The data is in kiloliters, and I convert it to thousand barrels daily in that file. The master file then links to it. I see the correct data, but not the conversion, which I’d like to be able to see.

Any advice on the best way to go about this will be very helpful.

Regards
Vic

i appreciate your help. I do, however need to see the actual formula, but i'm not sure i completely follow. I get the replacing function, but how do i copy the formula down to other cells,. It asically just copies the cell formula from the first value, so maybe i'm doing something incorrectly.

I'm attaching a file (Excel file 2) which shows what i'd like to do.

thanks for your time and help.

theres a typo in that sheet, the conversion is for cell c2, not c3. thanks!