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.
Bookmarks