From the course: Excel 2013 Essential Training

Unlock the full course today

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

Using formulas to link worksheets and workbooks

Using formulas to link worksheets and workbooks - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Using formulas to link worksheets and workbooks

Sometimes you need to write a formula that gets data from different sheets within the same workbook. At other times, you might need to write a formula that gets data from another workbook. In this movie, we need to have two files open, one of them, 09-04-RegionalSales, the other one, 09-04-EmployeeTable. Let's go to the RegionalSales file first. There's a sheet called RegionalTotals and we want to get Retail Totals there in cell B2. Each of the four sheets preceding this, East, Mid West, South and Pacific, all have a Retail Total in F4 and then below that a Wholesale Total and an Internet Total. So let's start where we want to put the formula, that's Regional Totals, in cell B2 and when you write formulas that get data from different worksheets or even different workbooks, by all means, Click the various locations using the mouse or the trackpad rather than typing in file names and sheet names. We begin with equal sign here. We'll Click the East sheet and then Click the cell that has…

Contents