Drop Down Menus

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