I have workbook A, which has 20 sheets in it, that I work out of consistently. There are 3 sheets out of this workbook that I would like to put into a new workbook, and put it in the public folder of my dropbox so i can share it with my partners. These sheets are active, meaning I am editing the content and formating as data etc. is being entered and arguably consumed.
I know how to have data transfer over automatically, I know you can copy paste, etc. I also know what happens when you just use formulas to transfer data, it doesn't transfer formating.
Is there a way to make Sheet A in Workbook A identical including data and formating to Sheet A in Workbook B.
I'ts like I want to right click on the sheet tab and be able to make it equal to another sheet in another workbook..equal in all ways.
Thanks in advance.