I need an automatic Excel-based quote generator built to replace the current manual Excel-based version. My company sells industrial equipment and price is based on system size, features and freight charges based on delivery miles and system size (e.g., oversize deliveries cost more). Each system currently has dedicated tab in a pricing spreadsheet and we enter the appropriate price into a manual Excel quote form based on the size and options. I need a quote generator that a) generates a quote with correct descriptive language per system; b) inserts customer data including name, address, phone number and email; c) generates a quote # and date; d) inserts price based on size and options pulled from the price sheet mentioned above; e) inserts a single line of text describing chosen options and pricing into the quote; f) calculates freight; g) calculates subtotal with options, plus a total with freight.
Variable text in red in the attached.
10 pekerja bebas membida secara purata $1016 untuk pekerjaan ini
I am an Excel Expert and can make a automatic calculator in excel Relevant Skills and Experience Excel Expert, VBA Proposed Milestones $1411 USD - Initial