Use loop to filter, copy/paste to new sheet; run through entire li

[ryguy7272]

How can I filter all items on a sheet named 'Summary Sheet' in Column C, then
run a macro?

I already have the macro, which calculates unique items on Row 3; will just
call it here.

Finally, copy paste the results from the filtered list and Row 3, to a sheet
named ‘Rep Summary’, skip a row for the next copy/paste procedure, then loop
back to the beginning and do it again until I have done this for every item
in the list? This seems to be harder than I initially thought...

Thanks,
Ryan---

 

[ryguy7272]

That code is great! I've seen something similar on Ron de Bruin's site. The
only problem with that is that I get over 300 sheets when I run this kind of
code. I was hoping to fund some kind of solution that summarizes the
information, on one single sheet, rather than giving me many, many,many
sheets to deal with.

Any other ideas?

Thanks,
Ryan---