I’m working on a company phone list. I would like to have a master list that has all employee names on it. One column in the master list will be called “LOC” for the location where the employee works.
If I assign a value to each location, is there some sort of coding or formula that can copy entire rows of data that have a match with the location value to another sheet?
APG is 1
WASH is 2
WEST is 3
BLUFF is 4
INFAN is 5
Ie:
Master list has a complete list of all employee names.
Sheet 2 is called APG which has a value of 1.
Sheet 2 will then have a full list of all the employees from the master sheet that work at the APG location.
And all changes to the master sheet will update in the following division location sheets.
Please help!!
Bookmarks