I have a spreadsheet, with two workbooks,
One has a list of every employee, the other has those same names in three separate columns each column headed with a Team Name.
I was the first sheet with the list to have a column with the team they are in next to them, and for this to update as I update the second sheet.
Is this possible?
One has a list of every employee, the other has those same names in three separate columns each column headed with a Team Name.
I was the first sheet with the list to have a column with the team they are in next to them, and for this to update as I update the second sheet.
Is this possible?