Hi,

I have a spreadsheet with a helper column. I understand you cant copy and paste correctly from filtered list into adjacent cells. So I'm having to un-filter list then highlight start of orig filtered list cell beginning to end (including blank cells) and then Paste Special skip blanks.

Is there a solution to this where can leave the filter on and paste into left of the cell from N to M?

Many Thanks
Gareth