Link two cells to automatically update

N

Nathan

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
 
E

Excelenator

Am I missing something or cant you just type in the formula

+Sheet1!F3

Into Sheet2 Cell D15
 
N

Nathan

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

tim m

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

Gord Dibben

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
 
N

Nathan

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
 
G

Gord Dibben

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
 
T

tim m

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
 
G

Gord Dibben

First re-format as General before F2 and ENTER


Gord

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
Click to expand...

Gord Dibben MS Excel MVP
 
Top