Hi there,
Please find the below code
Scenario1
I'm trying apply a filter on column C using Autofilter and then using the SpecialCells to copy only the visible cells which belongs to the column C. Further, pasting it in another workbook.
Scenario 1.png
Scenario2
I'm trying apply a filter on column D using Autofilter and then using the SpecialCells to copy only the visible cells which belongs to the column D. Further, pasting it in another workbook.
Scenario 2.png
Attaching the Excel file for your reference at the end.
Request you to please help me with this.
Thank you.
Book3.xlsx
Bookmarks