Paste range of values into filtered sheet
 

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!!! :(


--
ken2005
------------------------------------------------------------------------
ken2005's Profile: http://www.excelforum.com/member.php...o&userid=24734
View this thread: http://www.excelforum.com/showthread...hreadid=472010

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 wrote:

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!!! :(

--
ken2005
------------------------------------------------------------------------
ken2005's Profile: http://www.excelforum.com/member.php...o&userid=24734
View this thread: http://www.excelforum.com/showthread...hreadid=472010

--

Dave Peterson

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? :)


--
ken2005
------------------------------------------------------------------------
ken2005's Profile: http://www.excelforum.com/member.php...o&userid=24734
View this thread: http://www.excelforum.com/showthread...hreadid=472010

I think that is the fast way.

ken2005 wrote:

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? :)

--
ken2005
------------------------------------------------------------------------
ken2005's Profile: http://www.excelforum.com/member.php...o&userid=24734
View this thread: http://www.excelforum.com/showthread...hreadid=472010

--

Dave Peterson