Loop through list of unique values to copy & transpose data

Hello,

I have a rather large spreadsheet with multiple columns and multiple rows.

What I am trying to achieve is this:

1) Generate list of unique values. The original values are located in column Q. I can use RemoveDuplicates to generate a list of unique values.

2) In Column Q, autofilter the column using each of the unique values (one at a time) and then copy data in column AL to transpose into another sheet (starting at B2)

3) In the new sheet, there will be column names and row names. The row names will be the list of unique values generated from column Q, the column names will be a list of unique values generated from column D.

I've tried looking online (vba beginner here) and this is what I've come up with so far:

Please Login or Register  to view this content.

The most problematic area for me is getting excel to loop through column Q for each unique value and then getting it to transpose paste into the AreaTable sheet.

I'm definitely a beginner at VBA (but trying to learn!) so any comments/explanations accompanying code are certainly welcome.

Somehow, someway, I managed to get it done myself. I'll post the code here for anyone who's interested but will be marking the thread as solved.

Please Login or Register  to view this content.