need info from page one to reflect on page 2 &3

[Cindy]

The info one page one needs to be reflected on page 2 & 3 Automatically

 

[Allllen]

imagine on sheet1, you have "hello" written in cell A1

now go on sheet2. in cell A1 on sheet 2, write
='sheet1'!A1
(or just write = and then go and select cell A1 from sheet1, and press return)

 

[Jean-Guy]

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]

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

 

[Allllen]

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