I have a business in which I have leads that are provide to me.
I make calls to my different leads through out the day. I want to maximize
my efficacy.

I have the following columns

1stcallResults offset of 9

1stCallHour offset of 10



2ndResults offset of 13

2ndHour offset of 14



3rdResults offset of 17

3rdHour offset of 18



Hour is a range of 1-24 and is based on MY local time (PST)



I am trying to figure out the best way to reach my contacts. If I get a
message or other wise not talk to my contact (Result would be LIVE or
APPOINTMENT SET if I did talk to them) I would like to have a filterflag
(help column?) (lets call it NextContact) that will tell me when best to try
them again.



I have my day broken down into basically the following

First Period

Midnight -9:59



Second Period

10-1:59



Third

2 - 4:59



forth

5-11:59



Here are my shift preferences of calling times. Note, I might make my first
call during any one of the shifts and sometimes they MIGHT be different
orders depending if the contact called me back or something.



1, 4, 3 and then 2





If I tried calling somebody in period 1, and did not reach them, then I
would want to make period 4 my next preferred shift.

If I tried calling the cust on period 1 and 4 , then I would want my next to
be period 3



If I called the cust on period 3 4 and 2, I would want it to report period 1

And if NO contact attempts have been made (all time fields would be empty,
as would the result fields) then leave the next contact column empty



Again, they may not be in any given order.



If I have made a contact, then I would like the period I made the contact
the suggested shift

I know this would basically be done with some if statements, but I am not
sure how to build it. I am not sure if this should be a nested of using
elses or what...



Or would I be best using 4 helper columns with a logical flag in each
(Period1, Period2, Period3, Period4) and then test to see if any of those I
was able to reach the contact and if so, flag it as T, otherwise F.



What would be the best way? Quickest?



I HOPE this is clear....





Now that I have FILTERS working in my Userform, I want EXCEL to start doing
my work for me! Currently I am just physically LOOKING and my efficiency is
not what I would like it to be!



To further complicate matters (this I think I can add in once I get the
above worked out...but just so that you are aware and if you can provide any
suggestions)

I have two other fields (besttime1 (74) and besttime2 (75)) these *might* be
populated with a time range that is given to me to try to reach them. This
would be the BEST time to reach them.



I will also need to factor in timezone adjustments, but.... I can add that
portion in.



TIA!



Bruce