how do you link spreedsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to link two sheets so tha the information from one automatically
updates the other. What do I need to do to make this happen???

Thanks!!!!
 
iceman44 said:
I need to link two sheets so tha the information from one automatically
updates the other. What do I need to do to make this happen???

Thanks!!!!
Click to expand...
 
Easiest if both worksheets are in the same workbook.

Assume you want worksheet1 to be updated from the data you fill into
worksheet2.

For each CELL in worksheet1 that you want updated information, type = and
then go to worksheet2 and click on the appropriate CELL.

Note: In my experience, you need to color or otherwise mark worksheet1 so
that you remember NOT to enter information directly into it but remain with
the links.

does this help?
 
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

how do I export excel spreedsheet to outlook address book? 2
spreedsheet help 1
how can i use template wizard with data tracking in excel 2007 1
hOW DO i COPY FORMULAS FROM ONE SPREADSHEET TO ANOTHER IN EXCEL 1
Where do I add this Macro 3
How do I put page numbers on a spreedsheet? 2
how do I print the contents of a cell that is over the max limit? 2
Auto fill of specific text. 2

Back
Top