Thanks for those guys, but it's not really what I'm after.

I have a dos function that takes a list of product codes and adds
around 100 pieces of information to a csv.

Most of the standard requests for info are set up by simple macros.

What I'm trying to do is deal with the less frequent requests.

I'd like to have a sheet where all the available fields are in column
A, the user then picks which ones they want by ticking column B - then
the macro goes off and brings back just those columns.

I would adapt your answers to add extra functionality; if the user
chooses to see sales for months Jan to Jun 2005, I could then just show
the summed sales af those months.

Thanks again

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=556979