I'm working on a large list of data that has individual's names in column D(starting in D5) and each row lists data on transactions. Ultimately, for each individual there are many transactions. I currently have the data filtered so I can click a person and see all their transactions, but I want to go a step further.

I want to run a macro that combines each individual (each auto-filter "checkbox" option) into one line item, i.e. summing all their transactions into one row, and spit this consolidated data into a new worksheet.

I figure that piggypacking off auto filter may prove more efficient than a complex lookup formula that has to constantly re-cycle the entire list.

Is there a relatively easyish way to do this?