At work I have various spreadsheets that I save on my own network drive. Other relevant people in the company wish to view, not necessarily edit, the files that I create so that they can see what deliveries have been made. Is there a function that will allow me, when saving the spreadsheet it automatically duplicates and updates that spreadsheet to a common drive, not my own or not a folder on my drive. I know I could save the spreadsheet originally on the separate drive, but it would require me to password protect it for editting and I would keep getting rung up to come out of the file for them to view it. I am still learning a lot about Microsoft Office, a super set of progs.