EXCEL DATA

[Louise]

I have a spread sheet full of codes, descrpitions and prices saved on excel.
At the moment when I do a job sheet, I have to open up the saved one and a
new one and copy and paste the codes in need.
I would like to know if the is a way i could type the code is want in a new
spread sheet and it bring up the information i need, with out having to copy
and paste from one sheet to another sheet.

 

[Louise]

Hi,

I have the codes, descriptions, units, and price in they own column all
saved on one spread sheet. I want to be able to open a new sheet and type in
a code and for it to them bring up the rest of column relateing to that code
next to it.
Any ideas

Thank's