How can I use autofilter to run through the list of items? I'm getting
data and column R is product ID. I would like to filter the first item
in the list, run some code on it and then move to the next item until
it has gone through the enitre list. I can't figure out how to do this
though.

Thanks in advance