Display data in form from worksheet using Filter

V

VJ

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
 
T

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

VJ said:
Hi,

I need to pull the data from the worksheet to the forms using Autofilter
Click to expand...
or filter. I am also new to the filter coding.
I have four columns in my worksheet ie: ID, IDName, Parent ID,
Click to expand...
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.
 
Top