need macro to filter and paste data

  • 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

  • Please provide a sample of two or more sheets showing what those sheets would hold after the filter is applied. I'm not certain I fully understand the final result.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!