Mar 10 2021 04:10 AM
I am trying to copy cells exactly from one worksheet to another with formatting but get a spill warning. Data seems to only come over once I click the "merge & center" button but then formatting is all out.
Mar 10 2021 04:58 AM
Copy cell styles from another workbook
or use Copy & Paste
STRG+C & STRG+V
Hope this information will help you.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Mar 10 2021 05:56 AM
Thanks but its not quite working how I need. I need document 1 to automatically update document 2, including formatting.
So for example on doc 2 A1: K100 is where I want the data from doc 1, which I get but its not in the same format.
Doc 1:
Doc 2:
I think it has something to do with the merged cells?
Any help would be appreciated, thanks