Pasting unfiltered data next to filtered data in Excel

Solution 1:

It doesn't seem there is any built-in Excel functionality to do this. Your only recourse will be writing a VBA routine to paste into visible cells.