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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookups - how to obtain data from a master spreadsheet into another 5
Excel Excel spreadsheets opening at top instead of bottom. 4
Copy or Link Selected Worksheet 1
Excel 2002 1
Excel shortcut options 0
Auto Change Formulas - Please Help. 2
Alt codes 4
automatic formatting 5

Back
Top