Paste range of values into filtered sheet

[ken2005]

Hi,

I have a worksheet unfiltered that have a range of values that I like
to copy and paste it in another worksheet that is filtered. How can I
do that? I have try to select the visible cells in the filtered sheet
but it only works for single cell.

Please help!!!

 

[Dave Peterson]

It actually pastes into the rows that are hidden, too. You may want to go back
and see if you've harmed your original data.

I like to sort my "filtered" data so that when I paste, I can paste into a nice
contiguous range.

I'd show all the data, too--just to make sure I don't overwrite something I
want.

Then if I have to, I'll re-sort the data.

 

[ken2005]

Hi Dave...well looks like sorting the data on the sheet first before
pasting the range of data onto it seems to be a more practical way of
going about. Just wondering if there is a faster way, any idea?

 

[Dave Peterson]

I think that is the fast way.

Hi Dave...well looks like sorting the data on the sheet first before
pasting the range of data onto it seems to be a more practical way of
going about. Just wondering if there is a faster way, any idea?