In .com, D
Hilberg spake thusly:

Yes, Excel isn't quite wysiwig in this case (and for good
reason, though it can be inconvenient when doing what you are
attempting).

I don't really follow the limitation you are suggesting. In
Excel 2002, I just filtered a list, copied the rows, and pasted
them into a new worksheet, and only the filtered rows were pasted
into the new sheet. That seems to be what the OP wants.

--
dman

=================
You could copy the hand-written notes into Comments (or drag the
lot of them to be side-by-side in an adjacent column) to get rid
of the intervening rows.

Sorry not to be more helpful,

- David

On Jul 15, 12:52 pm, Jerry1Gman
wrote:

I am trying to copy a colume of data from a filtered list to a
second filtered list. But Excel keeps pasting into the hidden
rows also. This second list has every other row blank for hand
written notes.