| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling Data from one sheet and grouping it on another
This is basically taking a checkbook register and dumping it into budget
categories on a different sheet. If I have 5 Checkbook entries on sheet 1: GAS $60.00 Groceries $150.00 GAS $75.00 Clothes $35.00 Groceries $47.00 I want to group all of the entries by category on sheet 2 to appear like this: GAS for the Month of April 2008 TOTAL $135.00 (Sum of the "GAS" Entries from Sheet 1) Groceries for the Month of April 2008 TOTAL $197.00 (Sum of the "Grocery" entries from Sheet 1) Clothing for the Month of April 2008 TOTAL $35.00 (SUM of the Clothing entries from Sheet 1) How would I go about doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from one sheet to another | Excel Discussion (Misc queries) | |||
| pulling data from one sheet to another | New Users to Excel | |||
| pulling data from another sheet | Excel Discussion (Misc queries) | |||
| pulling data from another sheet | Excel Programming | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
