| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I have excel setup so formulas is connected between sheets
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have excel setup so formulas is connected between sheets
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. EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 08:41:02 -0700, davenportgirl wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have excel setup so formulas is connected between she
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" wrote: 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. EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 08:41:02 -0700, davenportgirl wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have excel setup so formulas is connected between she
The A1 on each sheet was for example only.
You can link any cell on Sheet1 to any cell on Sheet2 Gord On Thu, 7 Sep 2006 10:11:01 -0700, davenportgirl wrote: 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" wrote: 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. EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 08:41:02 -0700, davenportgirl wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have excel setup so formulas is connected between she
Hello again,
I tried that formula and another screen pops up like it wants me to save it. "Gord Dibben" wrote: The A1 on each sheet was for example only. You can link any cell on Sheet1 to any cell on Sheet2 Gord On Thu, 7 Sep 2006 10:11:01 -0700, davenportgirl wrote: 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" wrote: 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. EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 08:41:02 -0700, davenportgirl wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have excel setup so formulas is connected between she
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" wrote: The A1 on each sheet was for example only. You can link any cell on Sheet1 to any cell on Sheet2 Gord On Thu, 7 Sep 2006 10:11:01 -0700, davenportgirl wrote: 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" wrote: 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. EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 08:41:02 -0700, davenportgirl wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have excel setup so formulas is connected between she
Happy you're sorted.
Gord On Thu, 7 Sep 2006 13:09:03 -0700, davenportgirl wrote: 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" wrote: The A1 on each sheet was for example only. You can link any cell on Sheet1 to any cell on Sheet2 Gord On Thu, 7 Sep 2006 10:11:01 -0700, davenportgirl wrote: 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" wrote: 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. EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 08:41:02 -0700, davenportgirl wrote: 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 MS Excel MVP |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have excel setup so formulas is connected between she
I will guess that your sheetname had a space in it so Excel opens the FileOpen
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 On Thu, 7 Sep 2006 13:02:02 -0700, davenportgirl wrote: Hello again, I tried that formula and another screen pops up like it wants me to save it. "Gord Dibben" wrote: The A1 on each sheet was for example only. You can link any cell on Sheet1 to any cell on Sheet2 Gord On Thu, 7 Sep 2006 10:11:01 -0700, davenportgirl wrote: 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" wrote: 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. EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 08:41:02 -0700, davenportgirl wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
| Excel not calculating formulas | Excel Worksheet Functions | |||
| how do you add formulas on multiple excel sheets | Excel Discussion (Misc queries) | |||
| Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
