00:00Here is one trick that you can do to change your relationship with Excel.
00:03I'm talking about moving or copying a worksheet from one workbook to another.
00:07Under normal or conventional setting, you'll take millions of clicks to get this done.
00:11The smarter way would be to right-click the worksheet in the context menu.
00:15You're going to select move or copy, and then you're going to select the worksheet that you want to copy,
00:19which is 503 and two books.
00:21I'm going to select new book.
00:23This will create a new workbook for me.
00:24And then you click OK, and it will create a brand new workbook containing the worksheet
00:28you move from the original workbook.
00:30Now, to actually make a copy of this worksheet 503 back to my original workbook,
00:34you're going to right-click on the worksheet again, move or copy.
00:38In here, you're going to select the worksheet 503, and then to book, which is your target,
00:42you're going to say tip 4, XLS, and then you're going to select where you want to insert that workbook.
00:47I'm going to say before worksheet 512, and make sure you put a check next to create a copy and
00:51click OK.
00:52As you can see, just before worksheet 512, that's a worksheet 503.
00:58aspMine.com
