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!

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!

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!

My pleasure ;-)

Cordially
Pascal

"DonovansMom" a écrit dans le
message de news: ...
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!