Pulling Data from one sheet and grouping it on another

T

tmadeira

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?
 
N

Norman Jones

Hi T,

Consider using Excel's Pivot Table tool.

If you are not familiar with pivot tables,
see Debra Dalglish's tutorials on her
Contextures site:

Excel Tips and Techniques
http://www.contextures.com/tiptech.html

Look for 'Pivot Table' in the alphabetic index.

Also see Jon Peltier at:

Using Pivot Tables and Pivot Charts in Microsoft Excel
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Additionally, see Microsoft at:
http://office.microsoft.com/it-it/excel/HA010346331040.aspx


and , for Excel 2007:
http://office.microsoft.com/it-it/excel/results.aspx?qu=tabelle+pivot&av=ZXL120
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Somewhat complex code to copy data from one sheet to another 9
Auto Copy Data from one worksheet to another 1
Custom Macro for pulling information into one sheet 0
Create if partial match then copy and paste data from one cell to another 1
Min and Max for Date Range in Report 4
Pulling/Collating Data from Workbooks 6
sum of mutiple entries on another workbook 6
Copy Data from One sheet to Different Sheets 1

Top