dear sir
I want to have the table in sheet two with one click in sheet one.
for each phone, total number of seconds for each calling type will be calculated as in sheet 2.
can you plase give the code ?
dear sir
I want to have the table in sheet two with one click in sheet one.
for each phone, total number of seconds for each calling type will be calculated as in sheet 2.
can you plase give the code ?
OSMAN
Hi Osman,
Maybe just me, but I opened the wb and still wasn't sure about what we're looking to do?
Mark
Hi,
It's a matrix he wants. Phone number in rows, 3 call types in columns, with total minutes of each call type in call type columns. Damn hard to explain tho, esp if your 1st language isn't Excel (I mean English).
Here' tis, tested _ONLY_ on the example provided!
Cheers,
dr
"Questions, help and advice for free, small projects by donation. large projects by quote"
http:\\www.ExcelVBA.joellerabu.com