I have a long list of product SKUs (in screenshot, Column “E”), about 1000 of them. I have been using autofilter to filter my excel file by one product sku at at time, calculate profit margins for only that SKU. And then advancing to the next SKU.
The problem is, since I have so many product skus, it takes a really long time to scroll down in autofilter, unselect the previous SKU, and select the next one.
Is there a way to automatically advance to the “next” SKU in a list? Or would there be a quicker way to do this somehow?
please see these screenshots: Imgur: The magic of the Internet