Saritha123
New Member
- Joined
- Mar 4, 2021
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
I have two sheets Pricing and Product_Discount as attached.
Pricing sheet data will start from Row5 and Product_Discount data will start from row 7.
Column 'P' from the Pricing sheet should be a list from Column 'D' of Product_Discount sheet.(these values are dynamic may increase or decrease).
In pricing sheet based on the Column Q value, if that value exists in E column of Product_Discount sheet, then respective value from the list in column 'P' of Pricing sheet should get highlight/select automatically.
Example:
If column 'Q' of Pricing sheet has a value -167%, then column 'P' of Pricing sheet should select 'Prod_Disc' (as Product_Discount sheet has a value Prod_Disc for -167).
Please help in a VBA macro.
Attached the sample excel.
Pricing sheet data will start from Row5 and Product_Discount data will start from row 7.
Column 'P' from the Pricing sheet should be a list from Column 'D' of Product_Discount sheet.(these values are dynamic may increase or decrease).
In pricing sheet based on the Column Q value, if that value exists in E column of Product_Discount sheet, then respective value from the list in column 'P' of Pricing sheet should get highlight/select automatically.
Example:
If column 'Q' of Pricing sheet has a value -167%, then column 'P' of Pricing sheet should select 'Prod_Disc' (as Product_Discount sheet has a value Prod_Disc for -167).
Please help in a VBA macro.
Attached the sample excel.