Thread: Transfer calculated data from one workbook to another.

This should be a simple task that I just can't solve. I'm trying to avoid VBS or some more exotic solution, and do this with a simple, manual, copy/paste.

I have a workbook representing 2 weeks elapsed time, that will turn into 26 workbooks for the year. There are a fixed number of rows of data, but this may expand over time, which is why I expect to do this manually. The leftmost column in the first workbook starts at 0.0 for each row. The rightmost column is a simple sum of the values entered for each day of the 2 week period.

I need to copy the values of the calculation for each row into the corresponding row of the next workbook so that I can pass forward the accumulated values through the complete set of workbooks. When I try to copy the "Totals" column, it copies the formula, and not the calculated value, and I get #REF in the new workbook.

I can't see exactly what you are trying to do, but I tend to simply "link" the two workbooks. In the desired cell in book2, I will have a formula like =[book1.xls]sheet1!$a$10 (I think I got the syntax right) that will transfer the value in book1, sheet 1, cell a10 into the next workbook.