Create Summary Tab w/ Data From Other Tabs

thanksthanks

New Member
Joined
Jan 10, 2014
Messages
4
Hello all, I have a spreadsheet with a tab for each salesperson and the leads that they received. At the top of each tab, there is summary data including efficiency ratios pertaining to that salesperson.

I would like to create a summary tab with all of the salespersons metrics on one sheet, along with summary statistics for all of the salespeople. Any idea how I can link to that information on one sheet so it is automatically updated when new leads are added? Thank you in advance!
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Latchmaker

Active Member
Joined
Sep 30, 2005
Messages
308
Understanding your terminology....If by a Tab you are meaning a worksheet within a workbook, and if by metrics you are referring to the summary data at the top of each worksheet then create an additional worksheet and just reference the cells from each salesman that you want to compile into you new worksheet....the summary for the group can be created off this new data.

EX: 1) Enter the = sign in the cell on the new worksheet you want to summarize data
2) Then Select the worksheet (TAB) you want to summarize data from
3) Then Select the cell within that worksheet (TAB)
4) Hit Enter

You should see the same information in your summary worksheet (TAB) this will update automatically
 

Watch MrExcel Video

Forum statistics

Threads
1,122,193
Messages
5,594,767
Members
413,933
Latest member
Msar5586

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top