Compare two columns f different excel sheets and insert if required

[Saritha123]

Hi All,
I have two excel sheets(Pricing and Product_Discount) in a workbook.
In product_Discount , I will have some predefined Category and Discount(%).
In Pricing tab clicking on Import CPL button it will import some data from another workbook sheet to this sheet.
Part of this below is the requirement,
Clicking on Import CPL button,
1. We need to copy (creating a new row after all the values) the Applied Discount % column value from Pricing tab to Discount(%) column of Product_Discount sheet, if that percent value not exists there.
2. While copying the Discount(%) values into Product_Discount sheet, need to generate automatic values under Category column as Prod_disc_1, prod_disc_2, etc..... for the copied % values.
3. From Product_Discount sheet now we need to highlight the discount category in Pricing sheet for the appropriate applied discount. (Discount category is of drop down type in pricing sheet.)
Clicking on Delete Discounts button from Pricing tab,
1. should delete only the discount (%) which have been added on clicking the Import CPL button but not the ones which already exists prior to this.

NOTE: Data in Pricing sheet will start from row 5.
Data in Product_Discount sheet will start from row 7.

Attached the same excel, as I am completely new to VBA and Macros, really need help here.

Thanks in advance.

[Saritha123]

Hi All, as with tight dead lines need to deliver this, kindly please help