Populating one worksheet with all lines from other worksheets
I know how to reference cells in different worksheets, workbooks and
documents - however I can't figure out to:
The first worksheet in my workbook I have designated as a MASTER. There are
9 other worksheets in this workbook, each being identical except for the
segregated reason that the record appears on each (date).
HOW can I get all of the lines on all of the subsequent worksheets to
'appear' on the MASTER so I don't have to copy them in manually. I want the
whole line, verbatim, plunked down right in the master.
Thanks to everyone for taking a moment to consider this and get back to me -
even if it's to say 'can't be done'. Fondly, Mindi
|