Excel Formula/Worksheet maybe Macro Question

T

Todd Beauchemin

OK. Heres what I want to do. I have my cell phone bill in Excel format
and I want to write a macro or get a formula together to go through and
sum up all the minutes by phone number.

So basically I have
555-5551 | 5
555-5552 | 3
555-5551 | 3
555-5553 | 4
555-5552 | 10
555-5551 | 2

I want to generate another worksheet or table like this
555-5551 | 10
555-5552 | 13
555-5553 | 4

Any suggestions on how to go about doing this? Tutorials or what have
you. I have very limited experience with Visual Basic within Office and
I've used the SUMIF function before to generate what I want but I would
like to automate the finding the condition process - i.e. unique phone
numbers - and get it more dynamic so all I need to do is cut and paste a
new bill in and have it automatically generate the report.

Thanks
~Todd
 
M

Max

Quite ideal to use a pivot table for this
(only a few steps to get there)

Insert a header row, and put in 2 headers for the source table, viz.:

Tel Min
555-5551 5
555-5552 3
555-5551 3
555-5553 4
555-5552 10
555-5551 2

Select any cell within the table

Click Data > Pivot table Report
Click Next > Next

In Step 3 of the wizard:
Drag and drop Tel within the ROWS area
Drag and drop Min within the DATA area
(It'll appear as Sum of Min)

Click Finish

The PT will be created in a new sheet to the left,
with the desired results:

Sum of Min
Tel Total
555-5551 10
555-5552 13
555-5553 4
Grand Total 27
 
T

Todd Beauchemin

Max said:
Quite ideal to use a pivot table for this
(only a few steps to get there)

Insert a header row, and put in 2 headers for the source table, viz.:

Tel Min
555-5551 5
555-5552 3
555-5551 3
555-5553 4
555-5552 10
555-5551 2

Select any cell within the table

Click Data > Pivot table Report
Click Next > Next

In Step 3 of the wizard:
Drag and drop Tel within the ROWS area
Drag and drop Min within the DATA area
(It'll appear as Sum of Min)

Click Finish

The PT will be created in a new sheet to the left,
with the desired results:

Sum of Min
Tel Total
555-5551 10
555-5552 13
555-5553 4
Grand Total 27

Thanks. That worked out great.

~Todd
 

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

Top