transferring data between sheets

  • Thread starter Thread starter kirstypie
  • Start date Start date
K

kirstypie

Is there a way that I can transfer data between two sheets
within the same document? I want it so that when I make a
change to Sheet 1, the change will automatically appear on
Sheet 2?
 
Hi
try the following
- goto sheet 2 , cell A1
- enter the equation sign '='
- now select cell A1 on the first worksheet and hit enter
You should see a formula like
=sheet1!A1

copy this formula for all relevant cells
 
Back
Top