Keerthi@21
06-14-2020, 07:14 AM
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 :)
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 :)