From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

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

Tabulating data from multiple sheets

Tabulating data from multiple sheets

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Tabulating data from multiple sheets

“

- We're looking at a workbook called 01 Sales by State. There are four sheets in it. We're currently looking at the Colorado sheet. As I click the sheet tabs at the bottom, notice that the layout of each of these sheets is going to be identical. The numbers will be different, but all of these text entries here and here are going to be identical, as is the title on top. There'll be a different state name in cell A, too. Click Arizona, see what's happening. New Mexico, and Utah. Different totals, exact same layout. And it would be sensible here to have a fourth sheet called a Summary sheet. It could be after Utah, it could be in front of Colorado. Eventually, this model might include other states. But let's say we want to create a total. How about a sheet that looks exactly like all these, but actually will be a summary? Tabulating data from each of the four. Now, one approach to begin with might say, let's take one of our states, let's say Utah, highlight all this data, copy, paste it…

Contents