PLEASE READ THE WHOLE TEXT BEFORE YOU ANSWER. THE PROJECT IS NOT TO CREATE A FULL TOOL.
I need an Excel / VBA expert to help me create a quotation tool for our sales staff.
The tool should hide and show different check box fields based based on which parts of the home our customers wish to renovate.
To give you an example:
If our customer want to renovate the floors in their livingroom our sales staff check the box for "Renovation of floors" in the "Livingroom" tab, the section with choices (a number of check boxes) appears. Here our sales staff select what the customer want to do e.g. grind the floors, or other pre defined choice that is in this section.
Based on which check boxes are ticked, a list of "Work that will be done" in a different tab is created. Each line item is also connected to a price list (USD prices per Square meter) from a different tab that creates a price calculation for the whole renovation.
The attached list is an example for one room. If you can help me create the functionality based on this I am happy with the assignment. Then I can continue on my own.
Dear Client I understand the scope of work exactly. And I ensure I can help you in this project. This can be done using vba. I need to see the setup of the file. Please contact me. Roy