I know someone on this board did this once. I googled for excel tutorials and didn't find anything very useful. That said, how can I put in multiple drop downs different computer parts IE 1 dropdown for the following: "ram" "motherboards" "cpus" and so forth. and have multiple unit cost cells for what I chose and a price 3 cell for a markup (for business) I really need help with dropdowns so I can get one cell to change its value based on the dropdown value. Once I get that down its should be easy to get a quote spreadsheet up and going. Should I do this in Access 2003? If so where is a good site to get this started. I am a curious small business owner!
Thanks,
~PCTech
|