Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 12th 10, 08:53 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I put the do not call list in excel...does not fit scorm Excel Discussion (Misc queries) 2 August 23rd 06 05:22 PM
Call up worksheet based on validated list SAP PoD Excel Discussion (Misc queries) 5 August 18th 06 08:54 AM
Call list length in formula steev_jd Excel Discussion (Misc queries) 2 May 17th 06 10:11 AM
HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST? la90292 New Users to Excel 5 February 3rd 06 05:08 PM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017