oh sorry jooel, i'll post the full code monday morning and let you have a look, thanks for all your help though, i think all i was doing wrong was just not calling the dependencies in correctly (by not including the full path) other than that i simply used your approach and then created a select-case to fill in 18 centres worth, the codes only been tested locally but i'll be testing it this week in each of our centres and i'll let you all know how it goes.

Anth

"He who talks too much and knows very little"