Ellias_Adelle
New Member
- Joined
- Sep 13, 2021
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hello,
I have a report that produces a spreadsheet where column B has last names and column C has first names. There are many tabs like this and that number of tabs may vary.
On a new tab named "Name Filter" I have set up Column A for Last names and a Column B for First names.
What I want to do is create a macro that views each row of the active spreadsheet and checks if the first name and last name are the same as any of the names on the "Name Filter" sheet. If they are not a match I would like to hid that row.
I've tried a number or different things, even trying to settle to just reference the last name, but I'm still having issues. Does anyone have some advice?
I have a report that produces a spreadsheet where column B has last names and column C has first names. There are many tabs like this and that number of tabs may vary.
On a new tab named "Name Filter" I have set up Column A for Last names and a Column B for First names.
What I want to do is create a macro that views each row of the active spreadsheet and checks if the first name and last name are the same as any of the names on the "Name Filter" sheet. If they are not a match I would like to hid that row.
I've tried a number or different things, even trying to settle to just reference the last name, but I'm still having issues. Does anyone have some advice?
