Holiday Planner

Hi this is a new thread

excel 2003

What I am looking for is the following

create a UserForm which would

1. select a name, range("B6:B45"))

2. select the type of leave - i. holiday
ii. sick
iii. other
iv. delete individual booked leave

3. select starting date of leave. dd/mm/yyy (type in date entry)

4. select finishing date of leave. dd/mm/yyy

5. the vba will need to match the name from a list of names .range("B6:B45"))

6. match the leave type selected (which should format the target cell(s) ie color to be used for leave type (a different colour to be used by leave type)

7. highlight horizontally between the start date" through to the finishing date, on to the holiday planner sheets by leave type.

the holiday planner sheets are based by day
8. January through to June
9. July to December

the UserForm highlight leave type by colour but should ignore weekends and public holidays although they would still be on the holiday planner

10. 1 form to populate both sheets

I do have a file that is under construction

password is abc

abc1.xls

Bump

Is this possible

Thanks Roy for looking

I'm not looking for a application being built from scratch

the vba code is there already, the vba works on 1 sheet at a time,
(2 separate userforms)

however I am looking for it to cover both sheets from the 1 userform

ie if user form on 1st sheet, input name, leave type, start date & finishing date do not match date range of 1st sheet then to populate 2nd sheet range date.

I have tried to amend the vba, but cannot find a solution

I would be grateful to any help

Toonies