From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Use worksheet names in formulas

Use worksheet names in formulas - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Use worksheet names in formulas

- [Instructor] In this workbook, 2 we've got a California sheet tabulating Furniture Sales, 3 and as I click on the Texas Sheet, 4 Florida Sheet, New York sheet, 5 they all have exactly the same layout. 6 The numbers, of course, are different. 7 What we'd like to do is set up a summary here. 8 And along the way we'll be writing formulas 9 that deal with data from different sheets. 10 The easiest way to create a summary sheet 11 will be simply to copy one of these, 12 let's say it's New York, 13 and we can simply hold down the control key, 14 drag this sheet to the right, let go of the mouse first. 15 We've got a sheet that's duplicate in every way 16 except for the name. 17 I'll double click this new sheet, 18 it's called New York 2, and simply type in summary. 19 For this to look like it's in sync 20 we'll change cell A to also to be summary. 21 But for the moment, 22 the data we're seeing is the New York data. 23 But…

Contents