Whether it's a data range or an entire worksheet, there certainly are going to…be times when you need to copy and/or move data from one workbook to another.…I currently have six workbooks open.…I certainly can't tell that at the moment, but I'm going to click the Switch…Windows button in the View tab in the ribbon and expose the six here.…I'd like to see for the moment all of these at once with the Arrange All button,…also on the View tab here.…And for the moment let's focus on this concept here, the two files on the left,…DivisionFiles and Chartdata2011.…
It so happen that one of the worksheets in this file is needed in the other file.…And furthermore, there might be some data that falls into that same category.…So temporarily, I'm going to expand by dragging the right edge of this rightward…and the same thing down below here in the Chartdata2011, and the data in…question might be this data right here.…Now before doing that, I am thinking where I need to copy this.…And in the workbook above and it doesn't necessarily have to be in an empty…
Released
1/7/2011- Navigating across worksheets and workbooks
- Displaying multiple worksheets or workbooks simultaneously
- Inserting, deleting, moving, and copying sheets
- Changing sheet names and tab colors
- Showing and hiding worksheets
- Creating linkage formulas among workbooks
- Locating and managing links
Share this video
Embed this video
Video: Copying and moving data and entire worksheets across different workbooks