Thread: change...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
alen_re
 
Posts: n/a
Default change...



I have a 'simple ?' question..

If I have 2 sheets..
In sheet1.. A1: 5 (lets say)

In sheet2.. A1: =Sheet1!A1

I want to leave number that I've got from sheet1.. when I change number
5 into something else.. so that I can change sheet1 A1: to *10*, and to
have number 5 in sheet2, becouse it calculated it before..

Sorry for my English if you don't understand me..

Thanks for help..


--
alen_re
------------------------------------------------------------------------
alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=502579