View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Use loop to filter, copy/paste to new sheet; run through entire li

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---


--
RyGuy