I am working on a file that will have one sheet for each person to enter their monthly hours on according to project number. There will also be a project sheet where the manager will select the person's name from a drop down list. I have it to where they pick Person 1 it will pull the data from Person 1 sheet. However, I would like data to pull from correct tab based on the dropdown name selected. That way the formula doesn't have to be specific to the row.
This is what I have for the row with Person 1 chosen. However, if someone would select Person 2 it doesn't change the data in columns D-O, Is there a way that if you select Person 2 it will update the values from Person 2 tab automatically without manipulating the formula for each row?
=VLOOKUP($C$1,'person 1'!$B$5:$O$26,3,FALSE)
Project Tab
Person 1 Tab
This is what I have for the row with Person 1 chosen. However, if someone would select Person 2 it doesn't change the data in columns D-O, Is there a way that if you select Person 2 it will update the values from Person 2 tab automatically without manipulating the formula for each row?
=VLOOKUP($C$1,'person 1'!$B$5:$O$26,3,FALSE)
Project Tab
Person 1 Tab