In short, I have filtered a worksheet by column A, and I want to copy/paste from column B to column C. Obviously I don't wish to copy/paste values from rows that were filtered-out here.
The above sounds ridiculously simple, right?
First I tried simply copy/pasting on the filtered worksheet. This appeared to select and copy only the filtered data, however pasting appeared to insert values into hidden/filtered rows - as you might expect.
So my initial research suggests I may wish to select the filtered data and press Alt+;, which is a shortcut key for Goto Special > Select Visible. Then just copy-paste.
CTRL+C correctly copies the filtered data, however when I go to paste the values into another column, it pastes into hidden rows as well.
Okay, so perhaps I should also "Select Visible" on the cells I wish to paste into as well? Nope - that gives me the error
That command cannot be used on multiple selections.
What am I doing wrong?!