What I am trying to do:
- Create an add-in that does a simple extended cost calculation = (unit_cost) x (units_per_pack) x (packs_per_carton)
- I want the calculation to be based on the column header (always in row 1) rather than column A, B, or C because in different spreadsheets the columns used in the cost calculations are in different places.
- The add-in will have a button/icon "Run Calc" and the calculated value along with the part_code and part_desc are populated in a new worksheet. Note, part_code and part_desc are the headers and may not be in the same location across spreadsheets
- Additionally, if the unit_cost or units_per_pack is missing, I'd like the calculation to to show missing_cost or missing_units_per_pack
I'd certainly appreciate your input on how to proceed with this.
Thank you
SB
- Create an add-in that does a simple extended cost calculation = (unit_cost) x (units_per_pack) x (packs_per_carton)
- I want the calculation to be based on the column header (always in row 1) rather than column A, B, or C because in different spreadsheets the columns used in the cost calculations are in different places.
- The add-in will have a button/icon "Run Calc" and the calculated value along with the part_code and part_desc are populated in a new worksheet. Note, part_code and part_desc are the headers and may not be in the same location across spreadsheets
- Additionally, if the unit_cost or units_per_pack is missing, I'd like the calculation to to show missing_cost or missing_units_per_pack
I'd certainly appreciate your input on how to proceed with this.
Thank you
SB
