Display data in form from worksheet using Filter

[Guest]

Hi,

I need to pull the data from the worksheet to the forms using Autofilter or filter. I am also new to the filter coding.

I have four columns in my worksheet ie: ID, IDName, Parent ID, ParentIDName. I need to pull the information from the worksheet in the two combo boxes. First combo box should have Parent IDs and when i click on Parent ID, the second combo box should display the IDs belongs to Parent ID.

I am thinking it would be very easy to solve this using filters.

Can somebody help to provide some assistance using AutoFilter or filter to do this task?

Thanks

 

[Tom Ogilvy]

You migh look at
Debra Dalgleish's site on how to do this:

Dependent lists - data validation
http://www.contextures.com/xlDataVal02.html

--
Regards,
Tom Ogilvy

Hi,

I need to pull the data from the worksheet to the forms using Autofilter

or filter. I am also new to the filter coding.

I have four columns in my worksheet ie: ID, IDName, Parent ID,

ParentIDName. I need to pull the information from the worksheet in the two
combo boxes. First combo box should have Parent IDs and when i click on
Parent ID, the second combo box should display the IDs belongs to Parent ID.