I know there must be a way of achieving this without writing a macro, and just doing a straight paste.

I have two columns (Column A and Column B) that contain 10 records. 5 records are filtered out; so, currently, only 5 records are visible. Now I have another column with 5 records on a separate sheet that is unfiltered. I want to copy those 5 records, and paste the data in Column C next to filtered data.

Excel pastes all 5 records, but some of the 5 records are not visible because they are in rows that have been filtered out.

How can I simply paste the 5 records, so to insert only into the rows that are currently visible without using a macro or a vlookup? I am using Excel 2008, although it shouldn't matter in this case.


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.

  • 1
    Can you provide a VBA code to use? – user218076 Dec 14 '18 at 15:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.