The standard method for copy-pasting or moving (cut-pasting) an entire Worksheet in a Workbook is clunky and slow. I discovered a far more efficient method by accident!
Old skool
The standard method and the method I have been using for years is to:
- right-click the Worksheet tab
- select Move or Copy
- select the destination Workbook (an existing or new Workbook) from the dropdown
- click OK.
Nu skool
A far faster and easier method is to:
- Have the source and destination Workbooks open
- left-click drag a Worksheet from one open workbook to the other
Efficiency in using a computer is the sum total of many, many small techniques and I encourage you to always seek out new and improved skills to make your workflow smooth!