Hi John,

I think the Parameter Query could be what i'm after.
would you be able to give me an example of how i would write this please?

http://www.dicks-blog.com/archives/2...xcel-external-
data-queries/

(watch out for word wrap!)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com