OOOPS! forgot to provide you with one necessary detail ...

In the column immediately to the right of the last employee on sheet 2,
in row 3, put a large number that is guaranteed to be greater than the
number of lines in the report, like say 65000.

I know this could be done more neatly, but if this method works, why
not go with it.

DOR