Hi
I need a macro
I will place the macro in a separate file (filter.xlsm)
I want to filter the data of column C that has AB in the cell & if column C doesn't have AB in the cell then entire row will be deleted
so the result I have pasted in sheet2 plz have a look (I have pasted the result in sheet2 only for understanding purpose the result will be in sheet 1 only)
The location(path) of each file is different
Thanks
Bookmarks