Paste to visible cells only (Excel 2010)

Hello folks,

I'm trying to copy data from column A (sheet2) in a filtered list to column A (sheet1). As column A (sheet2) is of course also filtered, I want to copy the visible cells (no problem) but then paste them to the visible cells to column A (sheet1) is a big problem.

I've checked through earlier questions on this subject to find an answer but it seems there isn't one - at least not a straightforward one.
All of them include using a code that did not work for me.

I appreciate your help

I dont think it can be done without a code.
I would have linked the cells in shee1 with sheet2...lets say enter a formula in B2 of sheet1 saying =B2 of sheet2.

I've attempted this as it was suggested somewhere else. But even if you create a formula like =Sheet1!A1 and drag down the formula to the other cells in the range it will include all the filtered cells as well.
I do not mind using a code though I did not find one that works for me and I do not have enough knowledge to create such a code.
I simply need to be able to paste data to visible cells only in Excel 2010.
Back with Excel 2003 that was not a problem and the software would skip all the filtered cells.

My suggestion. Close this thread and paste it under VBA instead of general believe me you will be amazed with the quality and speed of response.

Hello,

I attached a test excel sheet named test.xlsx
It contains Sheet1 - cells in Column A are filtered by color and sheet2 contains data in Column A.
I need to be able to copy A1 to A5 from Sheet2 and paste it next to the filtered cells in Column A from sheet1.