View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
uscbryan uscbryan is offline
external usenet poster
 
Posts: 1
Default Creating a call log help.


I am a loan officer. Every week my boss gives me 80 to 100 or so name
and numbers to call. I put them in excel. What I want to do is create
sheet that next to each name is a sort of an up down button. If I pus
it up it add a number. Down takes away a number. This will show ho
many times I contact the lead. Next to that I want another button (sam
type) to show how many times I make contact, and next to that a butto
that shows how many times I get an application from the lead. I wil
use these numbers to show the total times I dialed a lead to get m
ratio of how many times I made contact and how many times I converte
to a sale. I know how to do the basic division to get the ratios,
just don't know how to make the button. Now I just enter a number eac
time. But this is more time consuming when I am calling so many time
per day. If at all possible it would be nice to date and time stamp i
so I can keep track of the the date and times that seem to be mos
benifical to call and actually make contact. Is this something that i
very hard to create? Thanks a lot

--
uscbrya
-----------------------------------------------------------------------
uscbryan's Profile: http://www.excelforum.com/member.php...fo&userid=3581
View this thread: http://www.excelforum.com/showthread.php?threadid=55589