Help Filtering Multiple Columns from User Input on Different Sheet

[camx76]

Hi,
Very new to this site and also very new to macros as well. I'm wanting to filter from user inputted data on the attached "ExcelHelp1" into "ExcelHelp2" The columns are labelled the same as the boxes. This may be fairly simple to do, but I am struggling and any help would be greatly appreciated.

Thanks!

[walruseggman]

On cover sheet, what are the values being inputted into? Cells? Then which cells? Text boxes? Then what are the names of the text boxes? Something else?

And we would also need to know the names of your search buttons.

Uploading your workbook would help immensely, even if it is scrubbed of your actual data.

Also you say that the boxes and columns are named the same, but it looks like you have center and center #. Is this a mistake?

[camx76]

My apologies. I should have known to add that info. They are being entered into cells. I will upload the workbook. I have a couple macros written for the searches for the center #, Region, and District and also for the Reset Data, but they are basic and any updates would be greatly appreciated! The boxes for INV and Source System are basic drop-downs.

[walruseggman]

Here's the code for the Center Search button, the others will be identical but for the range, field, and column.

Please Login or Register  to view this content.

[camx76]

Thanks so much!!! This worked great for all of them!

Using these, would it be possible to use the filter with multiple search boxes? Like for instance if I wanted to search for a center # and Source system, or all three like a particular center number that has "Y" on the INV and also source system? I really appreciate the work you did here. This will already save me a lot of time.

[walruseggman]

This would filter based on all of the fields, you can add or subtract items from the arrays to do whatever combinations of searches you want.

Please Login or Register  to view this content.

[camx76]

Thank you so much for all your help. I'm going to have to play with this one to get it just right. You've been very helpful and saved me a lot of time! I may have another question or two tomorrow if that's ok?

[walruseggman]

Of course, no problem