How do I have excel setup so formulas is connected between sheets

D

davenportgirl

How do I have excel setup so formulas is connected between sheets?
For example: When I put in data on sheet 1 for a budget then on sheet 2
have the total that is the same as on sheet 1 I have to do each sheet
manually. I was told that if I was to change anything on sheet 1 it is
supposed to automatically change on sheet 2.
Any help would be appreciated.
davenportgirl
 
G

Gord Dibben

Basics of linking............

Assume in A1 of Sheet1 you have a value of 12345

In A1 of Sheet2 enter =Sheet1!A1 to return the value 12345

Other methods................

1. select Sheet1 A1 and type an = sign but do not hit ENTER.

Switch to Sheet1 and select A1 then hit ENTER key.

2. copy Sheet1 A1 and switch to Sheet2 A1.

Edit>Paste Special>Paste Link>OK>Esc.


Gord Dibben MS Excel MVP
 
D

davenportgirl

Thank you Gord,

So, I have to have each sheet using the same........ex...A1 ? Like A1 on
sheet 1 and A2 on the other. Can I connect the sheets if each cell is
different on each sheet
 
G

Gord Dibben

The A1 on each sheet was for example only.

You can link any cell on Sheet1 to any cell on Sheet2


Gord
 
D

davenportgirl

Hello again,
I tried that formula and another screen pops up like it wants me to save it.
 
D

davenportgirl

Gord.....Thank you so very much!!! I used the second step you stated and it
works!!!! You do not realize how happy this makes me lol I have been battling
this problem for a few weeks now.
I am forever grateful!!!

Michelle
 
G

Gord Dibben

Happy you're sorted.

Gord

Gord.....Thank you so very much!!! I used the second step you stated and it
works!!!! You do not realize how happy this makes me lol I have been battling
this problem for a few weeks now.
I am forever grateful!!!

Michelle
Click to expand...

Gord Dibben MS Excel MVP
 
G

Gord Dibben

I will guess that your sheetname had a space in it so Excel opens the File>Open
dialog looking for a file.

If you have a space in the name you must place the name in single quotes like
such.

='sheet name'!A1

If you use the = sign and ENTER method, Excel adds the quotes for you.

I apologize for not explaining this earlier.


Gord
 
Top