Hi I have a spreadsheet that has many cells to be updated by different departments. The full spreadsheet is in the final tab(sheet). I would like to create several other tabs which will be specific to each department. For example cells A to H will be completed by department X. I was hoping I could simply copy cells A to H from the main sheet to the sheet specific to department X and then apply some kind of link whereby all the data added on sheet X would copy to the main sheet. I would do the same for each department and then once working somehow make the main sheet read only with each department having a password for their own sheet thus only them being able to update. Any help in achieving this would be greatly appreciated.
Bookmarks