I use Excel to keep track of daily sales at a small store. I have 12 folders, one for each month. In each months folder I have 31 spreadsheets named 1-31. All 31 sheets are identical, and they list the cost, store price, profit, etc of each item in the store. If I want to change the price of an item, how can I do so on one sheet, and have it automatically change on all the others. Right now when I make a change on one sheet, I have to go through the process of using 'File', 'Save As', thirty times.
2007-02-26
02:53:34
·
4 answers
·
asked by
Scott
2