Hi,
If all you want to do is to display a sheet 1 cell value in sheet 2,
there is a very simple solution.
Firstly, determine the sheet 1 cell reference you wish to display in
sheet 2. e.g. cell c24
Move to the desired cell position in sheet 2 and type the following formula,
=Sheet1!C24
Either go through the above formula with your arrow keys or turn on your
'all punctuation" mode first.i.e. note the bang or exclamation mark.
Although I have never had call to use it, you should be able to add
additional items to the formula. i.e.
=Sheet1!C24+6
Although I am using Excel 2003, the above should work in later versions.
HTH
Neville.
On 12/10/2014 11:35 PM, Kristian Schou Andersen wrote:
Hi all,
I have a problem when using MS excel with WE.
Let me start by illustrating the problem with an example. I have two sheet;
sheet 1 and sheet 2. In sheet 1, I would like to refer to a cell in sheet 2. I
therefore type the equal sign and press control page down to go to sheet 2 to
choose the relevant cell. However, now i am standing in sheet 2 and the equal
sign in the formula bar has disappeared.
Can anyone of you recognize this problem and if so, can you help me with a fix?
Thanks in advance
Cheers JristianIf you reply to this message it will be delivered to the
original sender only. If your reply would benefit others on the list and your
message is related to GW Micro, then please consider sending your message to
[email protected] so the entire list will receive it.
GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage
your list subscription at http://www.gwmicro.com/listserv.
If you reply to this message it will be delivered to the original sender only.
If your reply would benefit others on the list and your message is related to
GW Micro, then please consider sending your message to [email protected] so
the entire list will receive it.
GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage
your list subscription at http://www.gwmicro.com/listserv.
