Excel macro to remind me a project is due

S

SS

I am using Excel as a database to keep all my projects logged. There are six users set up on a network who all have access to this file. I have a column (say 'D') for the projects' "Due Date". I would like to create a macro that will search that Due Date column for all dates that are within 45 days of the current day, then email the six users a list of those project numbers (say, column 'B'). This would not be an automatic function at startup, but would be done manually by the user.

Thanks!

EggHeadCafe - Software Developer Portal of Choice
IIS Network Load Balancing, Sessions and IP Affinity
http://www.eggheadcafe.com/tutorial...9-29beba341b2f/iis-network-load-balancin.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros 2
excel macros 3
Change date to days 10
Project Server and DNS 1
Task start/end dates from MS project to Workspace site 1
Macro to find odd due dates and move them 1
Reporting Database PWA 1
Bar Colours in MS Project 2003 2

Top