B
bldgmaterialguy
I have a master sheet of contacts and daily dated sheets following the master
sheet. All sheets are configured alike with: A is status, B is company, C is
contact, D is telephone number, E is street address, F is city, G is state, H
is zip, I is Source, J is type, K is product, L is last date contacted, M is
results, N is next date to contact. I currently copy a range of about 50
rows from the master list and paste them into a dated worksheet. I make
calls based on the dated sheet and enter information for the status, the last
date contacted, results, and next date to contact. The status column is
where I enter either NI for Not Interested, DC for Disconnected, ACT! for
placing that entry into ACT!, or a number for the number of working days that
I want to try calling that contact back (voicemail, busy signal, etc). At
the end of the day, I take the contacts with number status and copy/paste
them into the corresponding dated sheet in the future. What I would like to
do is to automate that step as well as to update the master list with the
latest update to the dated sheets. Can that happen?
sheet. All sheets are configured alike with: A is status, B is company, C is
contact, D is telephone number, E is street address, F is city, G is state, H
is zip, I is Source, J is type, K is product, L is last date contacted, M is
results, N is next date to contact. I currently copy a range of about 50
rows from the master list and paste them into a dated worksheet. I make
calls based on the dated sheet and enter information for the status, the last
date contacted, results, and next date to contact. The status column is
where I enter either NI for Not Interested, DC for Disconnected, ACT! for
placing that entry into ACT!, or a number for the number of working days that
I want to try calling that contact back (voicemail, busy signal, etc). At
the end of the day, I take the contacts with number status and copy/paste
them into the corresponding dated sheet in the future. What I would like to
do is to automate that step as well as to update the master list with the
latest update to the dated sheets. Can that happen?