Mr Excel Guru's
If on Sheet 1 I had a data sheet, with 1000 lines of data.
How can I automatically list all rows in Sheet1 that in ColumnA = name of current sheet.
ie sheet2="Smith" list all six Smith occurances
Sheet3="Jackson" list all 15 Jackson occurances
etc.
I know how to use the autofilter, but I was wondering if there is a quicker way to do this, as I could have 10-15 sheets to copy and paste.
Ray
If on Sheet 1 I had a data sheet, with 1000 lines of data.
How can I automatically list all rows in Sheet1 that in ColumnA = name of current sheet.
ie sheet2="Smith" list all six Smith occurances
Sheet3="Jackson" list all 15 Jackson occurances
etc.
I know how to use the autofilter, but I was wondering if there is a quicker way to do this, as I could have 10-15 sheets to copy and paste.
Ray