Excel Help

[PCTech]

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

[DoG]

Sephiroth did it but it took a whole lot of VBS coding to get it to work
I nearly went bald trying to figure it out- i gave up in the end.

[Sephiroth]

give me an email addy, and let me dig the cd out i have that project for school saved on and i'll send it to you later tonight , it's a TON of VB in Excel macros, so good luck reading it, lol

[Sephiroth]

nevermind, found it, here you go, i hope you have a decent knowledge of excel functions and VB

[DaMaster]

Thanks, I use excel at school, so this would be useful but I can't download it, it says "This menu has been disabled" and "You do not have permission to view this board" even when I log in

[Sephiroth]

try it again now

[PCTech]

Thank you septh! much appreciated! I also found a decent site www.mrexcel.com

its a pretty good site, free messageboard, I searched and found a way i just dont know how to do it! pretty bad huh? any tutorial sites that I find I will post them in the tutorials section

Thanks,
~PCTech

[greypigeon]

have you visited this site:
http://www.exceltip.com/st/TipOfTheDay/45.html

Lots of tips

[DaMaster]

Cheers Sephiroth!, Works now.

[Gfields]

I messed around with this a while back, but too late for Sephiroth's deadline.

It works differently. You might like to check it out. It's all coded, but not very well documented I'm afraid