I need a VBA macro or excel formula to do the following in the attached excel file
Column A to Column E has unique values
Column F to column EY has the data
I need to do following
1 . Filter unique values from column A to E one by one.
for example filter the first value from Column A and keep values from Column B to E same and paste all the corresponding data on these filters from Column F to EY in a separate sheet.
2 . Also indicate in that sheet which combination of filter is used for the data . for example indicate which filter is applied for the values from Column A to E.
I have attached the sheet