I have some drop down boxes on the front sheet of a workbook that read data from a list of references on the second sheet.
This leaves me with 8 cells of data that I then want to apply (an Autofilter I think is best?) to a 4th sheet called 'Simulator'.
Is it best to use a VBA routine for this (I think it's the only way?) and is it fastest to apply each filter separately or to send all 8 pieces of data across at once?
My Simulator sheet has around 10,000 possible combinations of the 8 pieces of data, so once the first filter is applied things speed up as a large chunk of data has been filtered out.
Sorry if I'm rambling, but haven't dabbled in VBA for about 4 years so just trying to make sure my thought process is correct.
I've taken a look at this thread, and it's similar to what I'm trying to achieve (although I should end up with only one result after all 8 peices of data have been applied to the filter):-