Excel spreadsheets

  • Thread starter Thread starter AngelEyes
  • Start date Start date
A

AngelEyes

how do i copy data from one sheet to another so that if the info changes on
the first sheet it will automatically change on the second?
 
Hi,
you can have formulas in the 2nd spreadsheet. enter in sheet 2 cell a1 this
and them copy it

=sheet1!a1
 
E.g. =Sheet1!A1
entered in Sheet2 A1 shall give the value of A1 in Sheet1 in A1 in Sheet2.
--
Regards!
Stefi



„AngelEyes†ezt írta:
 
Back
Top