Display annual Leave Dates by employee

Why dont you attach a sample output file that you would prefer? We can assist you in automating it further.

Basically when you select the employee on sheet "holiday form 2012-2013" it does everything I want it to apart from showing the dates already booked, data entered on sheets PLANNER FEB 13 - 31ST MAY 13 and PLANNER JUNE 12 - JAN 13 is broken down by employee and date of annual leave , you enter a "H" for 1 day holiday and "hh" for 1/2 day holiday

Sample of what I need it to show , say I select ID No 4 wayne it should show on sheet holiday form 2012-2013, I want it to show

HOLIDAY DATES ALREADY BOOKED ( display by by D/M/Y )

01/02/13 - 02/02/13 - 04/02/13 - 05/02/13 - 06/02/13 ( etc )

I have attached a much simliar worksheet,

Basically what I need

If you enter a Employee ID it will display that employees holiday already booked by each date in the adjacent box using the data from k2 :y18 where "h" or "hh" has been entered

Use this code in a blank module of your file -

Please Login or Register  to view this content.

You can put a button or an object on your page. As soon as the number is entered into B25, you can click the button and the dates will popup in E25.