Code to filter Sub Array from data set

Hi,

Im trying to filter a subarray from a data set using 2 criteria.
In the Data sheet I have the data and in cells G3 and G4, I have the criteria for company and marks which will be used to filter the data

I require the simplest code to filter the data using the entered criteria and paste into a new sheet ( "Result") sheet

I know how to do this using formula but require a VBA solution.

Also would require an error control if entered criteria is not found in the data set.


Thanks in advance.Sample sheet attached.

Hi,

The attached workbook should do what you describe. Whenever you change the value in G3 or G4, it will update the "Result" sheet. The VBA code is "event enabled", so it runs automatically when the values in cells G3 or G4 change. If either of those cells is blank, it won't change anything. If the data input doesn't match any of the data in the table, it will give a message saying no data matches and will not provide a Result sheet.

Hope that helps,

Dan

If you change the layouts of criteria range, it is much easier for AdvancedFilter and very fast.
This is still using AdvancedFilter with a little twist.

Please Login or Register  to view this content.

Originally Posted by djbomaha

Hi,

The attached workbook should do what you describe. Whenever you change the value in G3 or G4, it will update the "Result" sheet. The VBA code is "event enabled", so it runs automatically when the values in cells G3 or G4 change. If either of those cells is blank, it won't change anything. If the data input doesn't match any of the data in the table, it will give a message saying no data matches and will not provide a Result sheet.

Hope that helps,

Dan

Thanks Dan for the help!!
Exactly what I needed....

Originally Posted by jindon

If you change the layouts of criteria range, it is much easier for AdvancedFilter and very fast.
This is still using AdvancedFilter with a little twist.

Please Login or Register  to view this content.

Thanks jindon!!