Hi guys and gals,
I need help creating complex invoice that will contain menus with product names and be tied with the specific pricing for appropriate quantities.
In essence I wold like to open spreadsheet, select a product from a lulldown list, and enter quantity of the item bought and for the formula to get the price for that quantity and total it at the bottom. (there would have to be 4 different tiers of prices).
I know basic programming but am at a loss how to start on this one. Any help or tips would be gratly appreciated. If there is a specific section in the excel help files that deals with this topic please let me know which one it is so i can look it up.
Many thanks folks