Copy filtered data into filtered range in a separate sheet

Hi.
Lets say I have to copy 20 filtered values in column B in Sheet1 into 20 filtered cells in Column A in Sheet2.

How to do this.
I can copy the filtered cells in Column B in Sheet 1, using selecting the filtered range, Alt+; and then copying

How do I paste into the filtered range in Sheet2. When I select visible cells in Column A in Sheet2 and try to paste it, it gives the error
"This action wont work on multiple selections"

Originally Posted by vikas.trades25

How do I paste into the filtered range in Sheet2. When I select visible cells in Column A in Sheet2 and try to paste it, it gives the error
"This action wont work on multiple selections"

Try this macro:

Please Login or Register  to view this content.