Unfortunately, Excel for the mac has little of the functionality of
Windows Excel, and doesn't have the Querytables collections.

I'm seriously thinking of buying virtual PC so I can run Windows Excel! :)

Dick Kusleika wrote:
mrl

You need a parameter query. See here

http://www.dicks-clicks.com/excel/Ex...htm#Parameters

and here

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