Best to consider using just 2 source sheets for the entire year, each sheet
to house 6 months worth of dates (~180 days) from col D to col GA (Copy n
paste the col data sequentially from the 6 source monthly sheets). Then just
extend the formula fills in rows 100 to 194 to suit. Then use 2 destination
sheets, eg: Hols_1, Hols_2 to extract the results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"louiscourtney" wrote in message
...
Max
Thats absolutley perfect
Just one final thing
How do i go about adding all the months(which are on seperate tabs) to the
holiday sheet you have created
All the sheets have been set up exactly as the one we have just worked on
Looking forward to your response

Shane