Hi
I need a macro
sample files has been attached below
If column A of HOW.xlsm matches with column B of WHEN.xlsx then keep that row & if not matches then delete the entire row of WHEN.xlsx
I will put the macro in HOW.xlsm
WHEN.xlsx is not opened macro will open that and do the process and will save the changes made after runing the macro
WHEN.xlsx has first row as headers so ignore that
I will change the sheet name manually so sheet name can be anything
Bookmarks