Pasting onto filtered cells

[Mediaexcel]

it doesn't work!

I guess the concept is similar as when trying to paste onto hidden
unhidden columns.


Thanks
M.E

 

[Dave Peterson]

If you can sort your data so that the shown rows are contiguous, then you can
paste into those visible cells.

Then sort the data the way you want.

I use two helper columns.

The first one is a row number: =row() and then copy|paste special values.
I use that column to sort the data back to its original order.

The second one is a formula that mimics the filter--but returns true/false.

Then I sort by that second column, do the filter (on True) and paste my data.

then I show all the data, and resort it by that row column.

When I'm done, I can delete or hide those helper columns.