Macro to have user select Criteria

you could use a userform.
Depending on how many permutations you want, you could have say 4 text boxes in the form to enter the values then put them together as a string

Please Login or Register  to view this content.

If you upload a workbook, i could add one for you.

I have updated the workbook with a userform. The list box will be populated with non duplicated periods to select.
The Listbox is set for multi select so you can choose as many as you want. The selected items are then turned into an array and then the filter can be used. I think this is what you are after.

Sean,

A little confused,

This is great but I'm trying to follow the "Search" button in Worksheet1. I'm not sure what you did to get that there and how it calls UserForm1. My WorkSheet is a Different name so I know I need to change the code for that name.

Also, how would I incorporate this into the Code that I'm using. Do I Call/Show this from my Sub Procedure and what do I Call/Show for the Search Button to appear in the ActiveSheet ? Is the UserForm1.Show I have Highlighted what needs to be The Call/Show, or is it one of the other Sub Procedures names? I don't see the Code for the Search Button unless it is

Please Login or Register  to view this content.

My Code

Please Login or Register  to view this content.

Thank you so much!

im a little confused what you are doing.

are you opening a new file and using that data?
basically to get the userform to show you must somewhere call the code Userform1.show

This can be from either a commandbutton as i have used or you can add that line in another code if you want.
ie. if you maybe are opening another document and copying data into your master doc first and then call the userform1.show to use.

to add a search button to your own sheet, activate the sheet you want, select developer tab, insert,active control command button.
then place this on your sheet, change the size, right click and edit the name if required.
Then if you double click the button it will open the vba code sheet , and will add something like sub commandbutton1().
if you then enter userform1.show then your code is ready when you click the button.

Dont forget you will need to copy the userform from my document to your one.

hope this helps.