I have an excel sheet that is used to import scheduling data. As it is in a secure location with sensitive data, only a few people have access to the sheet. I would like to mirror that entire sheet to a read only copy in a different, unsecured, share location. I need this to happen automatically whenever a change is made to the original sheet without relying on the user to remember to save the copy to the other location. How can I do this? I searched on the forums, but the previous concepts seemed to be significantly more complex than I needed or referenced code and macros that were not included in the question. Thanks in advance for any help!