RE: VBA auto filter Iterate through each criteria

[Keerthi@21]

In my excel worksheet I want to apply auto filter in column A and B. Column B has only two criterias " Queso Cabrales" and "Scottish Longbreads" and column A would have Order ID like 10248,10249,10250 etc.... First, I need to select "Queso Cabrales " in column B and navigate to Column A and autofilter select criteria "10248". Now i want to copy the filtered data to another sheet starting from range B3. I need to iterate through each filter criteria available in Column A and copy paste the data to another sheet below the last filled data of each criteria.

once it is done. I need to do the same process as above for "Scottish Longbreads" filter.

Recorded macro and tried but the criteria in column A might be large and dynamic and lot of repeats would be there. Hence, I need the same in macro to execute it.Please suggest VBA help in it.


Thanks

[snb]

Do you speak Spanish ?
Why do you take this paid assignment without any knowledge of Excel ?