Recurrent work possible with the chosen freelancer.
The excel file is an order form used in a factory. A few functionnalities must be added. They are the following:
-Creation of a form in excel to calculate item customization costs;
-Modification of the total price calculation sheet.
Create a form used to add options about cost calculations.
When the user clicks on the field, the form pops up. The user has to fill the amount field for a list of items. This calculates the price to modify the item. There are two kinds of costs: marginal costs (must be applied to every unit created) and fixed cost (must be applied once for the item line).
After filling the form, the user can press the button print to print the font, or close to calculate the total price.
The cell linked to the filled form now has a color to indicate there is a form attached to it.
The user can access the form again by clicking on the cell.
***The old formulas and VBA code must stay functional.
The coding and testing should take less than 3 fours for an average VBA coder.