Forum Discussion
From different excel files to one
How to copy sheets from one book to another without resizing columns and rows, style? How do I get data from the original tables automatically (without copying)?
Copy the Excel table including settings
If you copy the contents of one table in Excel and paste it into another, all settings that you have made on the table will be lost.
It is better to duplicate the table:
Right-click at the bottom of the worksheet that you want to copy.
Select "Move or copy ..." in the context menu.
Then select a folder and the location to which you want to copy the data.
Also check the Make a Copy option and click OK.
Move or copy worksheets or worksheet data
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here