jimbrown21
New Member
- Joined
- Apr 10, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
I have a macro built which pulls employee information onto sheet 1 from a website so it can be current.
Column B= Employee ID
Column D= Employee Name
Column G= Manager Name
I would like to build a formula or macro onto sheet 2 which pulls info from sheet 1. I would like to put into column A&B on sheet2 the Employee ID and Employee name IF their manager has one of the two names which I typed into cells V1 and V2 on sheet2.
Anyone know how I would go about doing this function?
Column B= Employee ID
Column D= Employee Name
Column G= Manager Name
I would like to build a formula or macro onto sheet 2 which pulls info from sheet 1. I would like to put into column A&B on sheet2 the Employee ID and Employee name IF their manager has one of the two names which I typed into cells V1 and V2 on sheet2.
Anyone know how I would go about doing this function?