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.

 

[The Code Cage Team]

When you say "Bring up" the information do you want it in a box of it
own or on one row opposite the code number? how do you want it displaye
and do you want the information to change when the source info changes

--
The Code Cage Tea

Regards,
The Code Cage Team
http://www.thecodecage.co

 

[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