Hi,
I have two workbooks with different sets of data in them, both calculated differently, but need to manipulate the data results in the same way and have created the formula to do so in one book but would like to copy it to the other book so it works on that data.
Ill try to explain clearly using small amount of data but in reality i have lots. In Workbook "August1" i have data in cells A1 to A5 and data in cells B1 to B5 and in Cell C1 I have the formula A1+B1, in C2 i have A2+B2, and so on to C5 then in cells D1 to D5 i have a range or formulas to find the average, number of pieces of data, sum etc, of the data in Cells C1 to C5.
Then in Workbook "August2" again i have data in cells A1:A5 and B1:B5 but in Cells C1:C5 i have A1*B1, A2*B2 etc. but i still need the same formulas to be in cells D1:D5 as workbook "August1" ie average, product, count etc. I know if I use copy and paste between worksheets then it copies the formula and uses the data in that worksheet but if i try it between workbooks then it only copies the result of the original data and not the formula, I tried paste special but only get options for pasting a bitmap etc. There must be a way i can do this so i dont have to write each formula out again.
Thanks in advance.
Luke.