I have 2 sheets, both have auto filters applied. I need to copy the visible cells from sheet1 and paste them to only the visible cells in sheet2. Nothing I have found online allows me to do this. This is the closest I've seen to working. Sheets("Sheet1").Range("A1:B10000").SpecialCells(xlCellTypeVisible).Copy Sheets("Sheet2").Range("J2").PasteSpecial Paste:=xlPasteValues, Operation:=xlPasteSpecialOperationMultiply Any help is appreciated!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copy filtered range and paste to filtered range

Thread starter D3allamerican07
Start date May 7, 2018
Tags

cells copy filtered range visible

D3allamerican07

Board Regular

May 7, 2018

I have 2 sheets, both have auto filters applied. I need to copy the visible cells from sheet1 and paste them to only the visible cells in sheet2. Nothing I have found online allows me to do this.

This is the closest I've seen to working.

Code:

Sheets("Sheet1").Range("A1:B10000").SpecialCells(xlCellTypeVisible).Copy
Sheets("Sheet2").Range("J2").PasteSpecial Paste:=xlPasteValues, Operation:=xlPasteSpecialOperationMultiply

Any help is appreciated!