Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Particulars data Filter from sheet 1 to sheet 2 automatically | Excel Worksheet Functions | |||
How to filter data in another sheet | Excel Discussion (Misc queries) | |||
Copy/filter data in a sheet from another sheet | Excel Discussion (Misc queries) | |||
Can you filter sheet of data & on another sheet make four groups under each other? | Excel Programming | |||
Data Filter in protected sheet | New Users to Excel |