Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call List Macro
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I put the do not call list in excel...does not fit | Excel Discussion (Misc queries) | |||
Call up worksheet based on validated list | Excel Discussion (Misc queries) | |||
Call list length in formula | Excel Discussion (Misc queries) | |||
HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST? | New Users to Excel |