linking workbooks
 

Hello , Here is my problem . I have created a workbook template for balancing
reports. In the workbook there are columns for previously balanced reports
totals. After we complete the current balancing is there a way to link the
workbook back to the template to move the current data to the previous data's
column so the current becomes the previous for the next time we balance?

I hope this makes sense .
I would appreciate any advice .