LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Todd Beauchemin
 
Posts: n/a
Default Excel Formula/Worksheet maybe Macro Question


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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel files in separate program windows Jason Dove Excel Discussion (Misc queries) 27 October 24th 08 07:58 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
excel macro to update visio orgchart Anna Excel Discussion (Misc queries) 0 April 29th 05 11:38 AM
Saving Excel using Macro mrbalaje Excel Discussion (Misc queries) 4 April 20th 05 02:32 PM
How do I force an Excel macro to ask me which file and directory? Ramius Excel Discussion (Misc queries) 4 January 14th 05 03:26 PM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"