Hi,
attaching the sample workbook.
What I intend to go though the range of cells consisting the values which will be matched with another range on another worksheet and in case of match clear the matching cell in the 1st sheet.
Hi,
attaching the sample workbook.
What I intend to go though the range of cells consisting the values which will be matched with another range on another worksheet and in case of match clear the matching cell in the 1st sheet.
Clear?
Please Login or Register to view this content.
Works perfectly, thanks
Interesting approach to use advanced filter for matching and removal
You are welcome and thanks for the rep.
Your sheet layouts are just tailored for AdvanedFilter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks