ok, so i think you need vlookup
http://www.contextures.com/xlFunctions02.html
the basic idea is
in sheet1 you have
colA colB
code1 description1
code2 description2
in sheet2 you have
colA colB
*1 *2
*1 = this is where the user types their code (like code39)
*2 = formula here will be =VLOOKUP(A1,sheet1!A:B,2,0) and will return
description 39
if you have time it is worth going through the weblink above and testing out
different things for yourself
--
Allllen
"Cindy" wrote:
I tried both but they dont seem to work. this is a template in which they
want to put in order #'s and info, but dont want to paste or do more typing
then neccessary
"Jean-Guy" wrote:
Hi,
Try something like this in sheet 2 and 3:
=Sheet1!A1
any cell in sheet 2 and 3 containing this formula will show the value that
is in A1 of Sheet1, you can also do a Copy/Paste Special/Paste Link
HTH
Jean-Guy
"Cindy" wrote:
The info one page one needs to be reflected on page 2 & 3 Automatically