Drop Down Menus

To better understand what I'm saying I made a screen shot of the excel spreadsheet I have made. - http://img202.imageshack.us/img202/4237/picforhelp.png - The formulas in this screen shot aren't updated.

Ok i have an item database and I wanted to have a drop down menu under the description column where I can select the item and it automatically fills in a code to the product in the column to the left of it and the unit price 2 columns to the right. Right now I have formulas in the code column and a formula in the unit cost column and the only problem I have with this is if I want to manually type the price in for a product the formula is deleted and if this form drags on for days its not going to be easy to get the formula back. So if you if this is possible let me know. If I wasn't detailed enough with my description and not seeing the screen shot please ask for more information.
-Thanks a lot David W.

I'm asking a completely different question... and the screen shot is so u can visualize where the columns are that I'm talking about. I want know if its possible to select an item from the drop down and for it to fill in the description column the code column and the unit cost column instead of having formulas.

http://rapidshare.com/files/31504267..._Page.xls.html

Is the download-able workbook

Hey man im sorry im really new to this forum how do i go about uploading it to this forum?

Sorry common sense question... ok the downloadable link is in here now. If anyone could help me out with this it would be very appreciated... but this vba stuff i have no idea about ill try to read about it while you guys respond

correct I will be starting a new document every single time. I'm going to have this as a template and saving as a different documents every time I have a different client.

Yes Dave correct that's what I was planning on doing.

broro i don't exactly follow the terms your using. I'm a novice user of excel. yes the workbook I have in the attachment works perfectly right now but if I'd like to manually fill something in the unit cost the formula will disappear. If I'm working on this over a couple days and if I messed up the manual input and want to go back I'd have to go through the hassle of copying the formula back into place and doing that every time will waste a lot of my time. So what I was wondering is if I can get it when i select something from the drop down in the description column it fills in the description column and on top of that the code column and the unit cost column.

To explain how it works now is I have a drop down menu made for the description column and all you do is select the product. Then I have a vlookup in the code column where it looks up the product and matches the product code with this description. Then in the unit cost it looks up which code corresponds with which price. Extended cost which will stay looks at the quantity if there is a discount percent and will factor that in. if there isn't then it wont and then multiply the quantity by the unit cost.

My question:
So, basically is there a way to eliminate the formulas in the code column and the unit cost column by using the drop down of the description to fill in the code column and the unit cost column and keeping the structure of the template I made.

Yeah thats whats going to go down lol...

So can anyone help me out with this problem??

Yeah I was interested in following through with the vba/macros I'll read up on it right now.


Dave, like I said before it works completely fine until it comes down to manually inputting data. I'm going to be making a different workbook every time to keep the original pristine but lets say once i do make my new workbook and i manually input something over the formula and its wrong and i have to go back I may not be able to do the simple ctrl+z if I'm doing this over a couple of days.

So, for now can you guys answer this question? Is it possible for what I explained earlier? So lets say I keep the drop down for the description ok? And when I pick something from the description drop down menu it automatically fills in not only the description column but also the code column and the unit price column. Let me know if you follow

Its fine its done I did it in vba