hi folks

I have bult a workbook to create rosters for our ward
I wish to populate a list box with wekly dates. so the ward manager
selects one of the next four roster start dates
eg Sun 6 Nov / Sun 13 Nov / Sun 20 Nov
and creates a new roster sheet based on the selected start date

I have created the roster sheet, it counts staff above a certain
grade and the m/f ratio if anyone is interested
-remove-block

thanks for the great advice and support in this group
john
Images of home (NZ)
http:\\www.myplace.co.nz/home
What we are up to in the UK
http:\\www.myplace.co.nz