I need to solve the following either using a Macro or VBA using Autofilter.
Criteria
1. data is held in a Datasheet
2. Need to extract Data given a specific criteria e.g. say By a certain date
3. Copy all data that matches the criteria to a new workbook and Worksheet
4. The criteria is specified in the "new Workbook/Worksheet"
Note: In principal this will work with "Advanced Autofilter"
Solution Required.
1. That any user can change the criteria in the new Workbook" without going manually through the process of applying "Advanced Autofilter".
Please can anyone help
Please note I am not a VBA Guru, - so please be gentle -
Criteria
1. data is held in a Datasheet
2. Need to extract Data given a specific criteria e.g. say By a certain date
3. Copy all data that matches the criteria to a new workbook and Worksheet
4. The criteria is specified in the "new Workbook/Worksheet"
Note: In principal this will work with "Advanced Autofilter"
Solution Required.
1. That any user can change the criteria in the new Workbook" without going manually through the process of applying "Advanced Autofilter".
Please can anyone help
Please note I am not a VBA Guru, - so please be gentle -