how do you link spreedsheets

I

iceman44

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!!!!
 
I

iceman44

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...
 
I

its_my_dime

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?
 
Top