EXCEL DATA
 

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.

EXCEL DATA
 

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


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30448

EXCEL DATA
 

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

"The Code Cage Team" wrote:


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


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30448