| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
update info on 2 sheets @ same time
is it possible to change info on 1 sheet and make the info change on another
sheet @ same time? |
|
#2
|
|||
|
|||
|
Yes if you link them assume you put info in Sheet1 A1 then in Sheet2 A1 put
=Sheet1!A1 -- Regards, Peo Sjoblom "dg" wrote in message ... is it possible to change info on 1 sheet and make the info change on another sheet @ same time? |
|
#3
|
|||
|
|||
|
tried that and got update values dialog box. wasn't expecting that
"Peo Sjoblom" wrote: Yes if you link them assume you put info in Sheet1 A1 then in Sheet2 A1 put =Sheet1!A1 -- Regards, Peo Sjoblom "dg" wrote in message ... is it possible to change info on 1 sheet and make the info change on another sheet @ same time? |
|
#4
|
|||
|
|||
|
got it
thanks "dg" wrote: tried that and got update values dialog box. wasn't expecting that "Peo Sjoblom" wrote: Yes if you link them assume you put info in Sheet1 A1 then in Sheet2 A1 put =Sheet1!A1 -- Regards, Peo Sjoblom "dg" wrote in message ... is it possible to change info on 1 sheet and make the info change on another sheet @ same time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Functions and Update info | Excel Worksheet Functions | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| Time Sheets | Excel Worksheet Functions | |||
| Time Sheets | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
Linear Mode
