Hi,
I need help trying to create a macro.
I have column Row 1 - Headers - User name.
I want to create a macro that will copy the entire column into a new sheet IF the name in Row 1 matches a range of approved user names in another sheet.
See below example:
I need help trying to create a macro.
I have column Row 1 - Headers - User name.
I want to create a macro that will copy the entire column into a new sheet IF the name in Row 1 matches a range of approved user names in another sheet.
See below example:
Input Sheet | Approved Name Sheet | Return Approved Names with all column values on New Sheet | |||||||||
Value | Name 1 | Name 2 | Name 3 | Name 4 | Approved Names | Value | Name 1 | Name 4 | |||
Alpa | X | X | Name 1 | Alpa | X | ||||||
Beta | X | T | Name 4 | Beta | T | ||||||
Gamma | XX | X | Gamma | XX | X | ||||||