Join Dennis Taylor for an in-depth discussion in this video Getting data from other sheets using formulas and the INDIRECT function, part of Excel 2016: Managing Multiple Worksheets and Workbooks.
- In this workbook called linkage forumlas…there's data for four separate states on different sheets.…Same layout, and there's also a totals sheet.…And on this total sheet we want to show some of those totals…and we do this by way of what we call a linkage formula.…It's not uncommon in certain kinds of workbooks…and particularly workbooks where you've got month…after month or state after state,…where you want totals on one of the sheets.…And the way we get totals can happen…in a number of different ways.…First of all, if I want a total here for North Carolina…I'll go back to the North Carolina sheet…and scope this out a little bit.…
It's going to be data from cell G7.…And as I look at the other sheets too,…it's going to be in that same cell, G7 on those sheets.…Now, there are two ways to get information…in this cell here, cell B2, on the total sheet…if we want that North Carolina total.…The first method begins at the sending area…so to speak or the source data right here.…So with cell G7 selected I'm going to right click…
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