Hi,
I'm keeping spreadsheets for a family store that has all sorts of data... inventory, profit, payroll, sales, bills, tons of charts and pivots generated from this data.. you get the gist.
We are looking for a way to automatically pull data from the previous month's workbook and use it in several ways in the current month's. Previously, we have just copied and pasted, but this is becoming time consuming and error prone since our data is growing...
For instance, if I have a cell which displays the profit total for June in sheet 'Profit' of workbook 'june07.xls', is there a way I can have the cell right next to it automatically pull in the profit total from sheet 'Profit' in workbook 'may07.xls'.
I'm looking for something dynamic... I know how to set the cell to =() then select the Profit cell from the previous month... but this isn't automatic. I am looking to build something into our workbook template file so that when we open that template file it pretty much automatically knows the previous month and has all the historical data filled in where appropriate (the profit cell, employee hours worked... we currently have a 'current month' column but it would be nice to have a 'previous month' column automatically filled in... stuff like this).
Is this possible?
Hope this makes sense... any help/pointers would be great!! Thanks!
Bookmarks