Excel Formula/Worksheet maybe Macro Question

[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

[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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Todd Beauchemin" <Marauder328@hotmail.com> wrote in message
news:oIMse.6654$eM6.3391@newsread3.news.atl.earthlink.net...
>
> 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

[Todd Beauchemin]

Max wrote:
> 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
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Todd Beauchemin" <Marauder328@hotmail.com> wrote in message
> news:oIMse.6654$eM6.3391@newsread3.news.atl.earthlink.net...
>
>>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
>
>
>

Thanks. That worked out great.

~Todd

[Max]

"Todd Beauchemin" wrote
> Thanks. That worked out great.

You're welcome, Todd !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----