Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
excel macro to update visio orgchart | Excel Discussion (Misc queries) | |||
Saving Excel using Macro | Excel Discussion (Misc queries) | |||
How do I force an Excel macro to ask me which file and directory? | Excel Discussion (Misc queries) |