I have weekly sales worksheet with daily sales, discounts, costs etc. What I would like to do is produce one work sheet that will import weekly numbers, so I can analyse, chart produce monthly tax etc. automatically.
I am stuck on how to import those numbers from other worksheets automatically. I know I can do so manually but there has to be better way.
I just finished watching Excel Advance tutorial where I picked up some tips but couldnt find a way to solve my problem.
My files are 3569 011109.xls
next one 3569 011809.xls
next one 3569 012509.xls
I need to pick net 2 sales, net 3 sales, sales tx, transactions, labor, food cost, paper cost, discount etc. on a new spreadsheet so I can analyze, chart graphs, sales vs prev years, prev months etc.
I am attaching link to where sample of the files can be downloaded.
I am stuck on how to import those numbers from other worksheets automatically. I know I can do so manually but there has to be better way.
I just finished watching Excel Advance tutorial where I picked up some tips but couldnt find a way to solve my problem.
My files are 3569 011109.xls
next one 3569 011809.xls
next one 3569 012509.xls
I need to pick net 2 sales, net 3 sales, sales tx, transactions, labor, food cost, paper cost, discount etc. on a new spreadsheet so I can analyze, chart graphs, sales vs prev years, prev months etc.
I am attaching link to where sample of the files can be downloaded.
Code:
http://rapidshare.com/files/270709911/greenbook_2009.zip