Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Box Question
Good evening,
I have a spreadsheet comprised of telephone numbers called Column A), duration of the phone call (Column B), and whether the call was connected (Column C). What I am trying to accomplish is have the user search for whatever phone number they're looking for and return the total call time for connected calls. Can anyone help me with this? I have never used VBA with Excel, only Access, so this is totally new to me. Thank you in advance for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Box Question
Hello
Pivot tables should do what you want, so IMHO there is no obvious need for programming in this case. HTH Cordially Pascal "DonovansMom" a écrit dans le message de news: ... Good evening, I have a spreadsheet comprised of telephone numbers called Column A), duration of the phone call (Column B), and whether the call was connected (Column C). What I am trying to accomplish is have the user search for whatever phone number they're looking for and return the total call time for connected calls. Can anyone help me with this? I have never used VBA with Excel, only Access, so this is totally new to me. Thank you in advance for your help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Box Question
Hi papou,
You're right, I think this will work. Don't know why I was thinking so far beyond the pivot table. I really appreciate you responding to me, thank you. "papou" wrote: Hello Pivot tables should do what you want, so IMHO there is no obvious need for programming in this case. HTH Cordially Pascal "DonovansMom" a écrit dans le message de news: ... Good evening, I have a spreadsheet comprised of telephone numbers called Column A), duration of the phone call (Column B), and whether the call was connected (Column C). What I am trying to accomplish is have the user search for whatever phone number they're looking for and return the total call time for connected calls. Can anyone help me with this? I have never used VBA with Excel, only Access, so this is totally new to me. Thank you in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Input, into Input box question | Excel Programming | |||
Input Box Question | Excel Discussion (Misc queries) | |||
Input Box Question | Excel Discussion (Misc queries) | |||
Input Box question | Excel Programming | |||
Input box question | Excel Programming |