Hello all,
I have a dataset that I want to publish and allow users to select a range of records based on several criteria that are columns within the dataset. i.e. Year; Month; Category, Area.
My thoughts are to create a userform with list boxes that the user can select from and press a command button that runs a macro that finds all rows that match the criteria selected and copies them into a seperate worksheet for view or printing. In the same style as the auto filter works.
I have a couple of questions...
1) Is this the best method?
2) How do I code the dynamic named range (that i use as the row source for the userform list boxes) to display the unique values from the particular columns of the dataset - to provide the user with a relevant selection criteria. i.e only display months that are actually in the dataset rather than all 12?
Thanks all
I have a dataset that I want to publish and allow users to select a range of records based on several criteria that are columns within the dataset. i.e. Year; Month; Category, Area.
My thoughts are to create a userform with list boxes that the user can select from and press a command button that runs a macro that finds all rows that match the criteria selected and copies them into a seperate worksheet for view or printing. In the same style as the auto filter works.
I have a couple of questions...
1) Is this the best method?
2) How do I code the dynamic named range (that i use as the row source for the userform list boxes) to display the unique values from the particular columns of the dataset - to provide the user with a relevant selection criteria. i.e only display months that are actually in the dataset rather than all 12?
Thanks all