ALCON,

I am working with a couple of different excel 2010 workbooks. They both only have one sheet in them and that is all that will be put in them. One is located in the "Supervisor" folder and the other is located in the "Patrolman" folder. The one in the "Supervisor" folder has some information on it that can not be visible to all, so we wanted to create the one in the "Patrolman" folder for them to view. However, it is very annoying to update the "Supervisor" folder and then do the same thing in the "Patrolman" folder. So, with that said, I want to be able to update/change the data in the "Supervisor" folder and have the "Patrolman" folder automatically update. Any help will be greatly appreciated.

Wren