Auto Populate Cells Based on a Criteria

i have an excel sheet attached and I need to be able to auto populate the cells based on a criteria (Case Number) using VBA. I am able to do this using excel formula but it takes time to loaod the results so I thought it would be better to use VBA instead. Can somebody help me pls. thanks in advance

Hi danallamas

If I understood your requirement correctly then this solves:

Please Login or Register  to view this content.

You may try something like this to make it more robust.

Right click on Tracker Sheet Tab --> View Code --> Place the following two codes into the opened code window.
The selection change event code will insert a drop down list of Case Numbers dynamically when you select the cell C2.
The change event code will trigger a macro that will fetch the relevant data from the DumpSheet as per the case number selected in C2.

Codes on Tracker Sheet Module:

Please Login or Register  to view this content.

Code on Standard Module:
Now insert a New Module and place the following code into the new code window.

Please Login or Register  to view this content.

For details, refer to the attached. To test the code, select a case number in C2 on tracker sheet.

If you are just wanting to filter DumpSheet then add a ComboBox to DumpSheet with the following code:
In a std module:

Please Login or Register  to view this content.

ComboBox code

Please Login or Register  to view this content.