Hello, everybody!
I hope you can help me with a challenge I am facing.
I have a database with all employees in a worksheet. Employees are from eight different divisions (marked with acronym in column C).
I have eight additional worksheets - one for each division (names of worksheets will be the same to the entries in column C in master sheet).
I want the information of employees (the whole row) to be transfered to the sheet of their respective division. So, whenever I make a change in the master sheet, the change is effective in division's sheet as well. And if I add an employee to the master sheet, they will be automatically added to the division's sheet.
How can I do that?
Bookmarks