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

[Guest]

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

 

[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

 

[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

 

[Guest]

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

 

[Guest]

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

 

[Gord Dibben]

The A1 on each sheet was for example only.

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


Gord

 

[Gord Dibben]

The A1 on each sheet was for example only.

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


Gord

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[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

Gord Dibben MS Excel MVP

 

[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

Gord Dibben MS Excel MVP

 

[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

 

[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