From the course: Excel Quick Tips

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Transfer worksheet to another workbook

Transfer worksheet to another workbook - Microsoft Excel Tutorial

From the course: Excel Quick Tips

Start my 1-month free trial Buy for my team

Transfer worksheet to another workbook

“

- [Instructor] Here's how to transfer a sheet from any other workbook. In this case, we have two Excel files, file number one, which is the financial transactions and the file number two, which is the vendor list. We want to bring these two sheets in a single workbook, and I will show you just how to do that. I will go on my vendor list sheet right here, and I will right click. I will select the option to move or copy. This beautiful little pane will open right here. I will make sure to check down here, create a copy. If I click here on this dropdown menu, I will see a list of all my open workbook. I will select file one, which is the book I want to copy the specific sheet to. Click here, and then I will just click okay, and here we go. I created a copy of my vendor list in this Excel spreadsheet right here, and I have the two sheets in a single workbook.

Contents