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

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)


--
Allllen


"Cindy" wrote:

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

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

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

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