Display & Loop through all AutoFilter Criteria

[Aditya6412]

Hello,

I came across a thread on looping through all the AutoFilter criteria for a mentioned column in VBA but wasn't able to comprehend how the code worked (http://www.mrexcel.com/forum/excel-...ria-copy-cell-results-into-another-sheet.html). I hope you guys can help me as I'm working on a very similar process. (Relatively new to VBA)

I'm mentioning the steps I would like to accomplish with the macro.

Step 1 - Data (10 column wide) is copied from Sheets("DG") and pasted in Sheets("Calculations") - *Accomplished this
Step 2 - Apply AutoFilter to all columns - *Accomplished this
Step 3 - Loop through all AutoFilter (referred to as AF henceforth) criteria in column 7 and extract results for each criteria to Sheets("Results")

Step 3.1 - Apply AF to column 7 and copy and paste all available filter criteria in another part of the sheet (Say column 12 - Just for reference)

Step 3.2 - For first AF criteria, copy values in column 8 and paste in results sheet

Step 3.3 - Then apply second AF criteria and copy column 8 and paste in results sheet (offset (0,1))
Repeat process for all remaining criteria.

Thanks in advance guys. Hope my request is clear.

Cheers,

Adi