Hi,

I am trying to mirror data across worksheet. I am trying to create an excel file which would be useful for various depts in a company. It would have financial data, expediting data and document data. All the worksheets should have the same data. However, each dept. is allowed only to view his data. Only Manager dept can view all the data together. I can freeze and protect worksheets to prevent viewing of data. However, what I also want is auto update of data. Lets say that accounting dept. adds an extra column or a row, it should be mirrored in the remaining worksheets as well. Is there a way to do this in excel? Thanks in advance for your help.

-AGM