Searching blank fields in excel and exporting corresponding column values

[kamalnba]

Hi all,

Good Day!!


I have an Excel worksheet which has 3 columns Site, Place_ID and PCNAME. I am creating a form in which I want to search list Place_IDs which has Blank PCNAME and export it it excel. Can you please help in Code?


Thanks in advance.


Regards
Kamal Goswami

[mdmackillop]

Assuming PCName is Sheet1 Column C

Sub Test()
With Sheet1
.Columns("C:C").AutoFilter 1, "="
.Cells(1, 1).CurrentRegion.Copy Sheet2.Cells(1, 1)
.Columns("C:C").AutoFilter
End With
End Sub