I hope all of you are doing well. I am trying to write code but failed . My sample file is attached .
Result file (Commission) is attached for reference.
I want to do below
1: Add a column After C Column
2: Lookup C column Data from "Product IDs" sheet in Column D
3: Filter the Without #N/A Data from Column D
4: Filter the Commission Amount less than zero from column E
4: Select the Completed Filtered Data from Column A to E Paste Special to a New Workbook and Save it with Name " Commission"
Many many thanks in advance