is it possible to change info on 1 sheet and make the info change on another sheet @ same time?
D dg May 28, 2005 #1 is it possible to change info on 1 sheet and make the info change on another sheet @ same time?
P Peo Sjoblom May 28, 2005 #2 Yes if you link them assume you put info in Sheet1 A1 then in Sheet2 A1 put =Sheet1!A1
D dg May 29, 2005 #4 got it thanks dg said: tried that and got update values dialog box. wasn't expecting that Click to expand...
got it thanks dg said: tried that and got update values dialog box. wasn't expecting that Click to expand...
