Copying one worksheet cells to another worksheet

New Contributor

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.





2 Replies



Copy cell styles from another workbook

Copy cell formatting


or use Copy & Paste




Hope this information will help you.


I would be happy to know if I could help.



I know I don't know anything (Socrates)



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