I need an excel formula or Macro to do the following in my attached spreadsheet
1. In the input tab filter on each unique product in column A to identify possible combinations of product with each of the values in column B-D (see expected output tab).
2 . For each unique combination paste the values from column H in a separate tab.
3 . Do this for each product
I have attached the sample expected output in the expected output tab for product 1 but I will need to do the same for each unique product in my list.
Thanks in advance