View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mindi Mindi is offline
external usenet poster
 
Posts: 1
Default 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