| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summarize multiple worksheet detail on summary sheet
I have a workbook that has up to 31 worksheets named 1, 2, 3....which
contains db log information for each day of the month. Each worksheet has 2 columns (ColA=text, ColB=number): Worksheet1 ColA..............ColB TxtMsg1..........22 TxtMsg3..........1 TxtMsg4..........10 TxtMsg4..........3 TxtMsg7 .........24 etc....... Worksheet2 ColA..............ColB TxtMsg1..........3 TxtMsg2..........8 TxtMsg5..........9 TxtMsg6..........3 TxtMsg7 .........4 TxtMsg7..........2 etc....... Worksheet3, Worksheet4, ............. How would I create a Month Summary page that shows the sum of each unique value in ColA from all the sheets combined? Monthly Summary Sheet ColA...........ColB TxtMsg1.......25 TxtMsg2.......8 TxtMsg3.......1 TxtMsg4.......13 TxtMsg5........9 TxtMsg6........3 TxtMsg7.......30 etc.... TIA, Don |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
| Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
| Copying Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
| Summary worksheet referencing multiple worksheets | Excel Worksheet Functions | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
