Hi there,
I have attached one solution that I think works. It is not really a perfect solution (among other it needs some "copy down" of formulas). Perhaps someone comes up with a better solution (I experimented a little with Data / Consolidation. It worked but the result wasn't really satisfying regarding the layout etc).
Short explanation of my proposal for solution (see attachment):
In the sheet "Special" there are constant values in the yellow cells.
Here you also have to name your sheets in the green area.
The solution assumes that you have exactly one header line on each sheet and no empty rows between two records. It also assumes that there is at least one record on each sheet (except for the header). Finally it assumes that number of records on each sheet is given by looking at column A (on each sheet), of course "minus one" for the header.
In the master sheet I think (hope) the formulas speak for themselves. Just copy them "enough down" and make sure to do the same on sheet "Special". As you might notice on the sheet "Master", I have used "conditional formating" to avoid showing error values (= gives white text on white background).
Kind regards
Bjorn
|