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?