Hi all, i am relatively new to this but learning quickly.
I need help with my excel spreadsheet i'm making to use for quotations. I would like to have a drop down for the 3 purchase options of our products (Purchase, Hire and Hire from new). Then on the Item Information/product list, when an item is selected the relevant price to appear in an adjacent column labelled RATE. Each product will have 3 different prices based on the 3 product options. If that makes sense.
I have all the data/prices and products input into a separate sheet in the workbook. Please help.
The format is simple, Row along the top for 3 purchase options(in drop down list), with 3 rows below. Product(in drop down list), quantity (to be entered manually) and Rate(auto input based on purchase option + selected Product from list)
Along with a total amount at the bottom.
Any help is much appreciated
CSW
Bookmarks