Date Planner

**jamessaunders** · 08-13-2007, 05:57 AM

Hello,

I am scratching my head on this one and not getting anywhere, so help needed!

I am constructing a date planner, with a list of jobs on another worksheet.
I would like the date on the job list to update the planner:

i.e. If the job in the worksheet was attended on date 13/07/07, I would like a green box to appear in the planner worksheet for that date, in the corresponding site row.

If anybody can help I will be very grateful,

Cheers,

James

**boylejob** · 08-14-2007, 08:14 AM

James,

I have attached a file for you to play around with. I have not finished working on it, but I wanted you to know that your question is being addressed.

Right know it is using the button at the top of the Dates sheet to cause the coloring to be added to the Planner sheet. I would like for you to test this out and make sure it is marking the Planner as you would like it to. I have not had time to do a lot of testing on this so please put all kinds of dates in and see what happens.

I am currently working on getting the process set up so it will automatically mark the Planner as soon as a site is entered. I have just run a little short on time. Hopefully, I will be able to send you a second version later today or tonight.

**boylejob** · 08-14-2007, 10:44 AM

James,

Here is the version that should update the Planner tab as soon as a site is entered.

Here is a brief explanation of how it functions. The subroutine will trigger when a site is entered on the Dates tab via the Change event of that sheet. It will pass the row number to the subroutine called Post located in Module1. April 1, 2007 is hard coded in as the begining date of the Planner. The code looks at the date entered and calculated the number of days it is away from April 1, 2007. This is how it determines where to change the color of the cell.

You should get an alert message if the date if prior to April 1, 2007 or if a site is not entered.

I'm sure you will need to make some modification as you start working with this, but hopefully it will get you started.