Excel Scheduler

[jcowley]

Hello all,

First of all, this is my first post, so hi to all, and thanks for giving me access to this good forum!

My question is as follows;

I currently have two separate excel sheets. One shows a list of customers with dates that their car will be inducted into our workshop. Another sheet shows the list of spare courtesy cars available to give to the customer.

What I would like to do is, as I change the details about when a customer's car is due to be inducted to our workshop, for the second sheet to recognise which customers require a courtesy car, and automatically assign them a car based on the induction date. If a date changes, the sheets should reocgnise the change, and automatically assign the next available car. Therefore the two sheets need to be automated. Is this possible?

Many thanks

[rasel]

I just tried as per my understanding to your requirements. Have a look at the attachment. You should only change the customer name and dates on sheet1 and it will give you the car(s) available on that date. you can make any changes in sheet2.

[jcowley]

That's along the right lines of what I am trying to do. I will upload an example later today to show you how it is at the moment, and then try and add a bit more explanation to it. Many thanks.

[jcowley]

Please find attached an example of what information is recorded, and what I am looking to do. It is essentially a manual operation that i want to automate.

Many thanks