I have an employee roster and need to fill in a value in column D of the person's ultimate boss that reports to the President.
To do this I think I would have to do a VLOOKUP, check to see if that person reported to the president, and if not do another VLOOKUP until I met the condition.
I need some help with the macro and loop. Please!!
Here is what the sheet looks like, I filled in the answers by manually calculating them in YELLOW, but I need to automate this.
Thanks, Steve
To do this I think I would have to do a VLOOKUP, check to see if that person reported to the president, and if not do another VLOOKUP until I met the condition.
I need some help with the macro and loop. Please!!
Here is what the sheet looks like, I filled in the answers by manually calculating them in YELLOW, but I need to automate this.
Thanks, Steve
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Employee | Supervisor | Type | Group | ||
2 | Joe | Frank | Employee | Frank | ||
3 | Sally | Steve | Contractor | Steve | ||
4 | Mary | Steve | Contractor | Steve | ||
5 | Jeff | Frank | Employee | Frank | ||
6 | Lauren | Jeff | Contractor | Frank | ||
7 | Karen | Jeff | Employee | Frank | ||
8 | Mike | Joe | Contractor | Frank | ||
9 | Fred | Frank | Employee | Frank | ||
10 | Ron | Karen | Contractor | Frank | ||
11 | Burt | Karen | Contractor | Frank | ||
12 | Ralph | Kyle | Employee | Kyle | ||
13 | Frank | President | Employee | Frank | ||
14 | Steve | President | Employee | Steve | ||
15 | Kyle | President | Employee | Kyle | ||
Sheet1 |