Hello
I don't know of any way that you can have formulae relating to several other sheets which (at the same time) might be needed to consolidate the data.
However, lets assume that you really had one summary sheet to compile from several other sheets that a new data record might be entered in.
If you had both the summary sheet and say a managers sheet open, plus a "work area" to enter the data, then both sheets could be coded to
pick up what you enter in the "work area" (a third spreadsheet).
When completed, the formulae in the summary and the manager sheets would be valued out, and the work area template cleared down.
There would be a number of issues (eg):
1. Identify the next available line in each sheet
2. Deal with entering multiple records?
3. When to cast the data in stone (by valuing out the formulae)
4 Designing the template to cope with data variations. (If any)
This might take some time to get working but it would be possible I think especially if the benefits
are good enough.
Bookmarks