Nested if and or else or vb which is best?

Hey Sarah,

If looks like you are in an office and doing scheduling for workers. On your Specific Tab you have a column called "Job Type" that is sometimes "Job 1" and other times it is a date. This is bad. You need 2 columns here. One column for Date of Service and another for Job Number.

The first problem is to make your tables consistant. Add more data and explain why/when a message should show as "Already booked". Give us a bigger overview of this problem.

1) Perhaps simulate some results so we can see what you want and where you want it.
2) Do your limits include the appointment being booked? For example, can you book a THIRD first job, or is 2 the OVERALL limit?

Hi Marvin, Hi Lee

Thanks for pointing out the messy data *mortified*, I also bake so like to have everything in one place and ready before I start, I do know this needs tidying, it is test data only and I am rebuilding the entire thing and not ready as such for the data as yet.

To answer both of your questions in one go.

Colleague Will use this tool for 2 purposes -

1) To validate/query if the appointment date/type and area is available that they want
2) To record a specific appointment date/type and area so it can be included in the data for the next query

I would like them to be able to enter this detail in the simple check boxes on the input page which is a job type, a date and an area,

What is the Date? 08/09/2017
Which Area? Derbyshire
Job Type? 1st Job

then press the 'check availability' button,

which will run a script using this information, against the held data on the data tab to see if the rules as mentioned above are met, this will then return one of two outcomes

a) a pop up box states 'This is available, please continue'
b) a pop up box states 'This is not available, please choose a different date'

To be dead honest if I could simulate this I would possibly not need help, I am confident enough, I think, that I can work this out and write it myself I am just stuck on the getting started.
Everything I have developed so far with other tools I have been able to record a macro for elements and build out from that point. I cannot do that with this, and not sure why but thats an entirely new question, but do know I probably need a nested if function to validate my dates, area's and first job types, I am also reading around and learning INDEX and MATCH as possible routes with which to code this.

What I am not sure about, is how I express in VB the conditions for the 'wanted values', which will allow me to reference that in the nested if functions. I can reference the columns of data to check against and manage a few less than and greater than values. The need help bit is the input data and how I reference that?

It may also be that I have been blind sided and I can record a macro to help me, but I can get my hear around that either.
I have been trying to run this using some of the functions referenced above as straight forward formula, but with litte joy or inspiration.

I again must state I do not want a solution but some suggestions for best forward that I can explore for myself, hints and tips not solutions as I am teaching myself and learn well by experimenting

Thanks guys, aware I may have waffled LOL Apologies.