"master" sheet - that is, generate a list combining all lists

[loblibbin]

I have multiple worksheets, each of which is the same table but with different data for different sets. (Each has identical columns and types of data within the columns).

I want to have a sheet in my workbook that will go through and list everything from all of the sheets. Is there a decent way of doing this without writing code or manual copy/paste of everything? Lastly, would it be possible to have a column added to the master sheet to identify which worksheet that line came from?

[Bryan Hessey]

I have multiple worksheets, each of which is the same table but with different data for different sets. (Each has identical columns and types of data within the columns).

I want to have a sheet in my workbook that will go through and list everything from all of the sheets. Is there a decent way of doing this without writing code or manual copy/paste of everything? Lastly, would it be possible to have a column added to the master sheet to identify which worksheet that line came from?

Hi, and no, not without some code.

A macro something like

Please Login or Register  to view this content.

would do the trick.

hth
---