Build a quoting Excel spreadsheet to generate price quotes based on the price list, selected quantities and quoting rules
$10-30 USD
Maksettu toimituksen yhteydessä
Build an excel spreadsheet that generates price quotes based on the selection criteria.
- Spreadsheet contains a workbook-1 with a price list - items and a corresponding price of each item.
- A workbook-2 contains “solutions” with a list of supported solutions. Next to each solution, I want to be able to fill in a quantity desired.
- There will be a way to tie “solutions” and a corresponding “items” from the price list. Some solutions need more than one item. I need a way to make some of these items required for each solution and others will be optional. I want to have an automatic selection of items based on manually selected solutions and a set of corresponding rules.
- Based on the selections and what has been pre-programmed as required or optional, generate a list of all selected items in the workbook 3.
Projektin tunnus: #20022038
Tietoa projektista
4 freelanceria on tarjonnut keskimäärin $30 tähän työhön
I'm perfected in Excel and macro. I have developed many macro program in Excel. I can finish it in 3 hours. Hi. How are you? I read your description carefully and am very interesting in your project. I can start right Lisää
Hi Respected Sir, I hope you are fine. I can do this job quickly and efficiently. I have more than 4 years experience in data entry, web research word, MS.Excel. I am adept in all advance formulas of Excel like if-else Lisää