Searching for data based on a cell value

Hi Philip,

Thank you for your post. Please send examples of the spreadsheets and macros to forum@stl-training.co.uk so that we can have a look at the data and the code. This way, we can help you more effectively.

Kind regards
Marius Barnard
Excel Trainer

Hi Philip,

No this will not be fairly simple to do.

It depends on how you would like the output, which criteria you want in the search. If you look at the code in the example workbook it is very specific what the macro is doing with the input (week number). Which information you get in the output worksheet. You will need to do something similar for all the text criteria you want to use as input to the macro.

The source data is not setup for Pivot Table use (it is not a flat list). If the source data where in a flat list it would be more simple.

If it is the same text criteria you want to use every time you can create a userform and call custom views based on the auto filter.

I have attached a workbook with a simple example. If you press the filter tool button you will load a userform where you can select between 2 filter options (it can be any number of options). Click the drop down list (the combo box) and select an option. You can create a new sheet with the filtered data if you click copy to new sheet.

I hope that the code in the workbook can give you some good ideas.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector