Anbuselvam K
Member
Hi
As per the below GIF I am calculating RM Cost per kg in the column of BA and BB.
I would like to modify the code for the below changes.
1) RM Price and purchase qty should be in the new worksheet. not in the same sheet as of now.
2) Results of RM1 to RM10 Calculated and printed in AQ: AZ, Which should not be shown anywhere in the sheet.
3) Next to the RM Consumption Columns W and X need to produce the BA BB Values.
4) At present Columns BA and BB are worked by Excel formula, it is also included in the code.
5) With the present code, I am selecting Entire consumption and Entire RM Purchase to produce the results in AQ: AZ. I would like to run them one by one as per my selection range of rows ( one or more Productions as per selection in "L")
For example, If I enter Product 5 details from Column B to V again in the 16th row, it has to generate the BA and BB Values in the W and X Column without giving any input or selection range.
6) Also, I need to reverse the production too. If I delete any L column Values and run the code should reverse the RM add back to its place in the W to AP
Attached is the sheet with the code for your help.
1drv.ms
Thanks in advance.
As per the below GIF I am calculating RM Cost per kg in the column of BA and BB.
I would like to modify the code for the below changes.
1) RM Price and purchase qty should be in the new worksheet. not in the same sheet as of now.
2) Results of RM1 to RM10 Calculated and printed in AQ: AZ, Which should not be shown anywhere in the sheet.
3) Next to the RM Consumption Columns W and X need to produce the BA BB Values.
4) At present Columns BA and BB are worked by Excel formula, it is also included in the code.
5) With the present code, I am selecting Entire consumption and Entire RM Purchase to produce the results in AQ: AZ. I would like to run them one by one as per my selection range of rows ( one or more Productions as per selection in "L")
For example, If I enter Product 5 details from Column B to V again in the 16th row, it has to generate the BA and BB Values in the W and X Column without giving any input or selection range.
6) Also, I need to reverse the production too. If I delete any L column Values and run the code should reverse the RM add back to its place in the W to AP
Attached is the sheet with the code for your help.
RM Cost per kg.xlsm
1drv.ms
Thanks in advance.