Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pull data - Advance Filter
Hi,
I have an excel file with approximately 200 data entry (200 rows and 10 columns). I would like to build a second sheet to do advance filter but with a criteria cell in the second sheet; say for example I have a course number column with different course numbers. In the second sheet, I have cell A1 as an input cell... when I input on of the course number into cell A1, it would filter the 200 data and only display the 10 columns of information of the course number in cell A1. If I change the course number in cell A1, it would change accordingly. Do you think there is a way to build this in excel? Thanks in advance. |
#2
|
|||
|
|||
You could do this with programming to run the advanced filter when the
value in cell A1 is changed. There are some examples he http://www.contextures.com/excelfiles.html Under Filters, look for 'Product List by Category' lil''bibbib wrote: Hi, I have an excel file with approximately 200 data entry (200 rows and 10 columns). I would like to build a second sheet to do advance filter but with a criteria cell in the second sheet; say for example I have a course number column with different course numbers. In the second sheet, I have cell A1 as an input cell... when I input on of the course number into cell A1, it would filter the 200 data and only display the 10 columns of information of the course number in cell A1. If I change the course number in cell A1, it would change accordingly. Do you think there is a way to build this in excel? Thanks in advance. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a worksheet pull from a specific cell value in a separate wrks | Excel Worksheet Functions | |||
move data to a single cell and at the same same time filter the da | Excel Discussion (Misc queries) | |||
How do I pull data from a previous worksheet? | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |