Get data from other sheet, macro?

[Wade LEES]

Hi All i have been playing with excel for about two years but never ventured into the macro side of it.

i am creating a costing sheet in which i would like to be able to type the first letters of an item in my price list in sheet 2 colum A wich intern would then find the item in sheet 2 colum A to add it to the cell i am typing in Sheet 1 colum A and at the same time fined the price in sheet 2 colum B and insert it to sheet 1 colum B.

NB i cannot make the cells in sheet 1 = to sheet two as the there will be changes in recipes all the time so it has to find what i am typing and add it automatically

is this to much to ask from excel or is there some way of programing it ?

many thanks

Wade Lees

[davesexcel]

check out vlookup, here's a sample,
http://www.excelforum.com/attachment...her-sheets.zip
here's the link to the thread

http://www.excelforum.com/excel-prog...-droplist.html