Display data in form from worksheet using Filter
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
|