Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to know how to automatically update the following:
I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Put this in Cell D15 of sheet 2
=Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Am I missing something or cant you just type in the formula +Sheet1!F3 Into Sheet2 Cell D15? -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565226 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was unable to get it to work?
"tim m" wrote: Put this in Cell D15 of sheet 2 =Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I tried the following and did not get anything?
+Sheet1!F3 What I am wanting to do is just key in the information on sheet 1 and have it upadate to another sheet so I don't have copy,paste all day. "Excelenator" wrote: Am I missing something or cant you just type in the formula +Sheet1!F3 Into Sheet2 Cell D15? -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565226 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
- You put that formula as shown in sheet 2 D15.
- you then typed something into sheet 1 F3 and hit enter. - You then went back to sheet 2 and looked at D15? "Nathan" wrote: I was unable to get it to work? "tim m" wrote: Put this in Cell D15 of sheet 2 =Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes, I typed in the information and it did not work.
"tim m" wrote: - You put that formula as shown in sheet 2 D15. - you then typed something into sheet 1 F3 and hit enter. - You then went back to sheet 2 and looked at D15? "Nathan" wrote: I was unable to get it to work? "tim m" wrote: Put this in Cell D15 of sheet 2 =Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What does "unable to get it to work" mean to you?
Nothing happens? You get an error message? The file closes? Please explain. Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 09:24:01 -0700, Nathan wrote: I was unable to get it to work? "tim m" wrote: Put this in Cell D15 of sheet 2 =Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The formula that i type in is all that shows.
I want to type in information on the first sheet and assign it specific cells on the following sheets. Basically I am trying to get around having to type in all the info and then sit and copy and paste every week. Thanks, Nathan "Gord Dibben" wrote: What does "unable to get it to work" mean to you? Nothing happens? You get an error message? The file closes? Please explain. Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 09:24:01 -0700, Nathan wrote: I was unable to get it to work? "tim m" wrote: Put this in Cell D15 of sheet 2 =Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Nathan
Seeing the formula and not the result indicates that the cell you typed it in was formatted as text before you typed. Select the cell and hit F2 then ENTER OR.....on that sheet you have "View Formulas" enabled. Hit CTRL + `(backquote above Tab key) to toggle off. Gord On Wed, 26 Jul 2006 11:36:02 -0700, Nathan wrote: The formula that i type in is all that shows. I want to type in information on the first sheet and assign it specific cells on the following sheets. Basically I am trying to get around having to type in all the info and then sit and copy and paste every week. Thanks, Nathan "Gord Dibben" wrote: What does "unable to get it to work" mean to you? Nothing happens? You get an error message? The file closes? Please explain. Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 09:24:01 -0700, Nathan wrote: I was unable to get it to work? "tim m" wrote: Put this in Cell D15 of sheet 2 =Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The formula shows? the formula itself should not show up in the cell, only
in the formula bar up top. You don't have a space before the = do you? Or do you have that cell formated as text?, if so format it as general then reenter the formula "Nathan" wrote: The formula that i type in is all that shows. I want to type in information on the first sheet and assign it specific cells on the following sheets. Basically I am trying to get around having to type in all the info and then sit and copy and paste every week. Thanks, Nathan "Gord Dibben" wrote: What does "unable to get it to work" mean to you? Nothing happens? You get an error message? The file closes? Please explain. Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 09:24:01 -0700, Nathan wrote: I was unable to get it to work? "tim m" wrote: Put this in Cell D15 of sheet 2 =Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan |
#12
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
First re-format as General before F2 and ENTER
Gord On Wed, 26 Jul 2006 11:59:01 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Nathan Seeing the formula and not the result indicates that the cell you typed it in was formatted as text before you typed. Select the cell and hit F2 then ENTER OR.....on that sheet you have "View Formulas" enabled. Hit CTRL + `(backquote above Tab key) to toggle off. Gord On Wed, 26 Jul 2006 11:36:02 -0700, Nathan wrote: The formula that i type in is all that shows. I want to type in information on the first sheet and assign it specific cells on the following sheets. Basically I am trying to get around having to type in all the info and then sit and copy and paste every week. Thanks, Nathan "Gord Dibben" wrote: What does "unable to get it to work" mean to you? Nothing happens? You get an error message? The file closes? Please explain. Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 09:24:01 -0700, Nathan wrote: I was unable to get it to work? "tim m" wrote: Put this in Cell D15 of sheet 2 =Sheet1!F3 "Nathan" wrote: I need to know how to automatically update the following: I want to type in the information once into Sheet 1 Cell F3 (text) then have Excel automatically update the (text) I typed into Sheet 2 Cell D15 Is this possible? Thanks, Nathan Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically add "0" to blank cells without a formula in the cel. | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Adjust the size of cells automatically | Excel Discussion (Misc queries) | |||
Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
Update linked cells within a workbook??? | Links and Linking in Excel |