Hi Annie,

select the filtered range, press F5 click on Special button ans chose
"visible ceels only" (as my excel is on Braziliam Portuguese, maybe some
words are different)

copy and paste

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Annie" escreveu:

Hi I am using Excel 2000 and have filtered a list so my result shows for
example rows: 1 56 159 241 410 but when I copy and paste into a new
sheet I start in A1 to paste and the information goes into A1, A2, A3, A4,
A5. Is there anyway that I can get the pasted information to reflect the row
numbers from the previous sheet?

Many thanks
--
Kind regards

Ann Shaw