Copy & Paste only visible cells...

[Nitesh Kumar]

Hi Champ,


Kindly give the solution for Copy & Paste only visible cells, in attached sample there are two sheets, i want data from sheet1 to sheeh2 through copy and paste only in visible cells.

don't use vlookup.

 

[Villalobos]

Hi,

Is this VBA proposal help for you?

Sub CopyPasteFilteredData()

    Worksheets("Sheet1").UsedRange.SpecialCells(xlCellTypeVisible).Copy _
        Destination:=Worksheets("Sheet2").Range("A1")

End Sub

 

[Marc L]

Hi !

SpecialCells method is not necessary 'cause Copy like Delete methods
work only with visible cells ‼

OP must try just by activating Macro recorder !

Here is the formula forum, many samples in appropriate forum …
​

 

[Nitesh Kumar]

Hi,

I want extract data in sheet2 rows 3,5,7,9,11,13, which are same in sheet1.