I’ve had a number of requests to cover copying entire worksheets between files. The number one problem seems to be when the data is pasted into the new worksheet Excel doesn’t resize the column widths to fit the pasted data. Instead the columns seem to reset themselves back to the default width. Possibly the best way to avoid this happening is to use the Move and Copy command in Excel.
Moving and copying entire worksheets between workbooks (files)
In this tutorial you will learn how to quickly copy or move entire worksheets between workbooks. Covers the Move and Copy command as well as copying and pasting an entire worksheet without the columns resizing. Also covers problems copying and pasting between the new Excel file format and the old file format and the error message “Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook”.