edwedw
11-16-2011, 02:44 PM
Please see attached workbook as this isn't easily explained without a visual aid.
Using 'advanced filter' I would like a sub routine to take any data specified on the "filters" worksheet inside the box B5:P26 (which is also duplicated further over) and use this ascriteria for advanced filtering the data on "Customers" current range; A6:AT29 (List range).
The problem I have is that I need the flexibility to potential use all fields for criteria or just one if the others are blank, I cannot use auto-filters as this will be used in excel 2003 where there is a max of 3 criteria and would like this macro to create a friendly UI.
Apologies if I haven't made the problem clear, please ask me to clarify if so.
Any help or advice would be highly apprciated as I've been going around in circuls on this for days.
Many thanks in advance.
Using 'advanced filter' I would like a sub routine to take any data specified on the "filters" worksheet inside the box B5:P26 (which is also duplicated further over) and use this ascriteria for advanced filtering the data on "Customers" current range; A6:AT29 (List range).
The problem I have is that I need the flexibility to potential use all fields for criteria or just one if the others are blank, I cannot use auto-filters as this will be used in excel 2003 where there is a max of 3 criteria and would like this macro to create a friendly UI.
Apologies if I haven't made the problem clear, please ask me to clarify if so.
Any help or advice would be highly apprciated as I've been going around in circuls on this for days.
Many thanks in advance.