This question is to help a friend at work. Assume a workbook with a Main tab
On cell A3 is a dropdown where you can select up to 8 products which then limits the display on Main to that product.
Upper management asked that he create a separate tab for each view, i.e. Prod1 - Prod8 as separate sheets each showing the filtered data for that product.
He tried to record a macro, but cell A3 defaults to all products.
I assume he needs to create a loop based on the product names in the list range... any suggestions.