Hi,

I need a macro that can pick data from the data worksheet to another worksheet. I will attached the sample. My ideal result is if TTM is selected, please choose anything excep ORACLE if there are duplicate ids. If there is no duplication id that have ORACLE org. You can choose it. If YTD is selected, you can select all of them. Please refer to my result tab to see my expected results.

Test.xlsx

Thank you