I've created a Master worksheet tab in a workbook. This workbook was created
to show the weekly itineraries (M-F) of everyone in our department. This is
a large group of people and there if often movement, with people moving into
and out of the department frequently. Consequently, the names change often.
The Master tab lists the names of everyone in the department. All the other
tabs are on a weekly basis, with the names of the employees linked to the
Master tab. The idea was that when a name changed in the dept., to make the
change on the master tab and it would automatically update each of the weekly
tabs. This works if I'm typing over a name in the master, but I can't get it
to work if I insert a row in the master tab to add a name. The row isn't
inserted on the other tabs. Can you tell me how to insert a row on the
master tab that carries over to all the other tabs? Thanks for any
help/advice you can give me!