Using FM to automate an excel based pricing spreadsheet
I have an excel pricing spread sheet that i think I could make an automated quotation tool.
I have a base product in 10 different part numbers and depending on that base product, there are additional components that need to ship with it (ie. part number (depending on the size ordered) can get 3, 4, 5 or 6 of another component that must ship with them in order to make the base product functional.
Secondly, there is another component that will ship with the base that has two parameters: (1) of up to (6) different cometic styles can be selected AND there are up to 10 standard lengths for each of these different styles.
I want to develop a tool with drop down menu for the product and with each selection allocate the appropriate other components if that makes any sense...