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.

MikeeBrad1_0-1615378118186.png

MikeeBrad1_1-1615378157347.png

 

 

2 Replies

@MikeeBrad1 

 

Copy cell styles from another workbook

Copy cell formatting

 

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)

@NikolinoDE

 

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:

MikeeBrad1_0-1615384434950.png

Doc 2: 

MikeeBrad1_1-1615384482317.png

I think it has something to do with the merged cells?

Any help would be appreciated, thanks