Anbuselvam
Board Regular
- Joined
- May 10, 2017
- Messages
- 97
Hi
https://www.dropbox.com/s/lbmx4uus4481zgq/Extract Formula.xlsx?dl=0
The above link sheet has a product formula in sheet temporary and permanent.
In the sheet, Master data Column A and B are the dates and product name.
Each product has different formulations by 12 types of raw materials as per the sheet Temporary and Permanent.
I need to extract the formulations from those sheets to Master data according to the date in Column A and Product name in Column B,
To get the desired results I used two helper columns and other formulas in the above-linked sheet.
Please provide the code which can remove all these formulas.
Sincerely Yours
Anbuselvam K
https://www.dropbox.com/s/lbmx4uus4481zgq/Extract Formula.xlsx?dl=0
The above link sheet has a product formula in sheet temporary and permanent.
In the sheet, Master data Column A and B are the dates and product name.
Each product has different formulations by 12 types of raw materials as per the sheet Temporary and Permanent.
I need to extract the formulations from those sheets to Master data according to the date in Column A and Product name in Column B,
To get the desired results I used two helper columns and other formulas in the above-linked sheet.
Please provide the code which can remove all these formulas.
Sincerely Yours
Anbuselvam K