Placing a combobox and putting in
March
April
May

and placing a macro in the sheet module seems like manual work rather than
writing code.

You can use Ron De Bruin's site to get code to pull data:
http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy




"deejayh" wrote:


I Have a sheet with data unsorted:
Columns A to M. There could be from 50 to 500 rows of data.

In column I the data is a date (Months): 01/03/2005 or 01/05/2005

I have a sheet called code, where I would like to add a combobox for
each of the months, to select a month and for the data to be pulled out
and put into another seperate sheet.

Thanks
Dave


--
deejayh
------------------------------------------------------------------------
deejayh's Profile: http://www.excelforum.com/member.php...o&userid=34110
View this thread: http://www.excelforum.com/showthread...hreadid=546637