Hi JristianIf, I am using 2013 but this will work the same.
On your 2nd sheet go to the cell you want to reference from sheet 1 and copy the cell in Sheet 2. Next go to the cell in Sheet 1 where you want the cell from Sheet 2. Now use "Paste Special" On the Paste Special dialog screen TAB down to OK then Cancel and the next button is "Paste Link" That Paste Link will paste the contents of your cell on Sheet 2 and a formula reference as well. There may be a simpler way to do this but without vision and the rodent I do not know one. George He is wise who gives that which he cannot keep to gain that which he cannot lose. George A Martinez CPA, PC 12231 North 50th Avenue Glendale, AZ 85304-2215 Voice 602.368.8854 FAX 206.666.2589 Email [email protected] -----Original Message----- From: Kristian Schou Andersen [mailto:[email protected]] Sent: Sunday, October 12, 2014 6:36 AM To: [email protected] Subject: Cell references in excel 2010 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.
