Pasting in Autofilter table (visible cells)

Hello all,

I have a table with many rows and many colums, and I'm using autofilter. This table is being filled in manually by looking at a PDF document (with technical specifications) and typing every single cell with a value. To do this i'm using autofilter to have the same order in excel as in my pdf, which makes typing a little easier.

Every now and then I have a Lucky break and I see some technical specifications matches something I have already entered before. Then I copy the cells (visible only), and want to paste these cells in the next column (for example).

There is where it goes wrong the cells are then pasted also in the non-visible cells...

Never had this problem before (I think) working with excel2007, now i have excel 2013...

Anyone has any idea's?

Kind regards,
Peter

Hi,

Thanks for your answer, always appriciate it!

I will use this in the meantime so thanks... But I can't get over the fact that there isn't a simple option with a check/uncheck that will do will do this!!!

Peter,