Forum Discussion
Updating a formula over 12 worksheets using Data from the previous worksheet
I have a problem. I am working on an inventory map for the whole year gathering incoming and outgoing data daily on each worksheet. 12 worksheets- 1 for each month Jan.- Dec. I have a formula that I ...
In general it's best practice to keep all raw data in one sheet with month/date field for each item. From here you may build your monthly analytics, whatever. Otherwise that's INDIRECT. You may keep in some cell the name of previous sheet. Poor =INDIRECT(A1 & "!A3") won't give related references, perhaps you need to add combination with ADDRESS, depends on how you concrete formulae are located. Plus that's poor performance, each of such formula will be recalculated with every change in any sheet.
IMHO, to create once 10 formulae in each of sheet is less time consuming.
