ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Populating one worksheet with all lines from other worksheets (https://www.excelbanter.com/excel-worksheet-functions/120982-re-populating-one-worksheet-all-lines-other-worksheets.html)

John Bundy

Populating one worksheet with all lines from other worksheets
 
If i'm reading this right, you want the date and reason on each of the 9
sheets listed on the master? Is the data in the same place on each sheet or
must it be found? And finally you ask how to get all lines on subsequent
sheets, we need to know what needs to be brought over.
John

"Mindi" wrote:

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



All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com