From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using formulas to link worksheets and workbooks

Using formulas to link worksheets and workbooks

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using formulas to link worksheets and workbooks

“

- In this movie, we need to have two workbooks open. One, "09-04-RegionalSales", we're currently seeing. And, by pressing control-tab, the other one we need to see is "09-04-EmployeeTable". Let's look at the regional file first. We can also switch files by going to the switch windows button on the view tab, in the ribbon. Over to regional sales. Its not uncommon to write formulas that get data from other worksheets within the same workbook. And, in this workbook we've got sheets for East, Midwest, South, Pacific, and that's not a requirement for what we're about to do, at least initially. We've got another sheet called, Regional Totals. We simply want to write a formula here that gets data from the other sheets. I'm going to start with equal. Click on the East sheet. I'm aiming for the retail total, here. When I go to the East sheet, that retail total is in cell F3, so I'll click it, then a plus. And now I'm going to go to the Midwest sheet. These sheets do have the same locations, so…

Contents