Filter Data to another sheet
 

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 fo
each of the months, to select a month and for the data to be pulled ou
and put into another seperate sheet.

Thanks
Dav

--
deejay
-----------------------------------------------------------------------
deejayh's Profile: http://www.excelforum.com/member.php...fo&userid=3411
View this thread: http://www.excelforum.com/showthread.php?threadid=54663

Filter Data to another sheet
 

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

Filter Data to another sheet
 

Another way is to use Easyfilter to do this
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tom Ogilvy" wrote in message ...
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