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