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

  • Thread starter Thread starter Cindy
  • Start date Start date
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)
 
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
 
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
 
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
 
Back
Top