Copy_Paste filtered data using F5

[Neets]

Hi, I know how to copy & paste filtered data using "Visible Cells Only", but it only seems to work when you are pasting to an "unfiltered" spreadsheet. Is there a way to copy a filtered selection then paste that data back into the same filtered spreadsheet in a different column?

When I try this it only pastes the first cell in the range.

Thanks!

 

[p45cal]

I think you'll have to loop through visible cell by visible cell, probably using .offset.

 

[Neets]

I'm assuming that would be macro oriented? This is for a user who just wants to do the copy/paste visible cells on the fly.

Thanks!

 

[texasalynn]

it is actually pasting to the hidden/filtered rows

 

[Neets]

How do I do that?

 

[p45cal]

I'm assuming that would be macro oriented? This is for a user who just wants to do the copy/paste visible cells on the fly.

Thanks!

Right… if it's only values you want to copy across and the filter doesn't change between the copying and subsequent pasting, try this:
Filter the range
Select the destination range
Tweak with f5 visible cells
type in the formula:
=
(yes, just an equal sign)
then use the cursor keys to the left or right to the source column (no holding the shift key down or anything, just one cell),
then hold the Control key down while pressing Enter.
Then you'll have the problem of copy/paste-values of non-contiguous ranges unless it doesn't matter if the whole destination column is values.

 

[Neets]

Brilliant! It works and does not mess with the existing filter.

Thanks so much, will pass on to others!