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)?
If you want to copy one or more entire sheets:
- Make sure that both workbooks are open in Excel.
- Right-click the sheet tab of the sheet that you want to copy. If you want to copy multiple sheets, select them first, then right-click the sheet tab of any of the selected sheets.
- Select 'Move or Copy...' from the context menu.
- Select the target workbook from the 'To book' dropdown.
- Specify where the sheets should be copied in the 'Before sheet' list box.
- Tick the check box 'Create a copy'.
- Click OK.