Pasting filtered rows

A

Annie

Hi

I have a worksheet in Excel 2000 and when I filter it the row numbers read
for example: 1 44 66 124 359 etc. I would like to be able to
copy this and paste it into the adjacent worksheet but when I do it pastes
okay but the row numbers are sequential 1 2 3 4 5 etc. I would like to
see the actual row numbers from the previous sheet.

Is this possible?

Many thanks

Annie
 
D

Dave Peterson

Maybe you could add an extra column to the original data range.

Put the row number in each of those cells in that column:
=row()

Then filter and copy|paste.

If you paste values, then the numbers will show nicely.
 
Top