I had a similar case as yours. But mine data was some numerical values, after
i perform the SubTotal to each categary, when then full listed (level 3), i
copy and paste (paste special) all the numeric columns as "values" only.
Then when i go to level 2 (all the subtotals) which is a filtered list, i
copy all the data and paste again, it only gives me the filtered list.
Hope this is useful for you. You can treat your data as subtotal too and try
out.

"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.