Workbook contains 8 sheets. Seven are individual listings under category of cases and the eighth is a master list. Is there a way to automatically update the master list sheet whenever text is entered into one of the seven individual sheets? I have tried the paste special link, but that only puts the information into specific cells and not just the next available row in the master list. If anyone knows something I am missing or if it can't be done, please let me know.

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

Attached Files

MasterList3.xls (26.5 KB, 19 views)