Join Dennis Taylor for an in-depth discussion in this video Creating formulas that link worksheets in different books, part of Excel 2016: Managing Multiple Worksheets and Workbooks.
- [Instructor] In an earlier movie, you might have seen…how it's necessary and appropriate to write a formula…in one worksheet that's getting data from…other worksheets from the within the same workbook.…And there can be times when you got different…workbooks open, of course, that's different files open,…where you write a formula in one file,…that's getting data out of other files.…Right now, I'm looking at a workbook called State Link.…I've got three other files open.…One's called Colorado.…Another New Mexico.…Another called Utah.…And as a reminder that I have them open,…on the View tab, Switch Windows,…here are all the files that are open.…
I'll just to New Mexico, it looks like this.…Back to the View tab, Switch Windows, Utah.…Back to the View tab, Switch Windows, Colorado.…And by the way, you can switch between workbooks…a bit more efficiently with Control Shift Tab.…Here are the different workbooks.…Now, in this workbook here, called State Link,…I want a sales total here from the Colorado workbook,…and New Mexico, and Utah.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with different worksheets together
- Copying and moving worksheets within a workbook
- Linking formulas across multiple workbooks
- Changing tab colors and renaming sheets
- Copying, moving, and inserting data on different sheets
- Working with multiple workbooks
- Navigating workbooks
- Getting data from other sheets with 3D formulas