Input Box Question

[Guest]

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!

 

[papou]

Hello
Pivot tables should do what you want, so IMHO there is no obvious need for
programming in this case.

HTH
Cordially
Pascal

 

[Guest]

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]

My pleasure ;-)

Cordially
Pascal

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.