Thanks Brian - that's a big help. Best wishes, Robin Williams Met Office summer intern - Health Forecasting [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Lee Sent: Tuesday, August 05, 2008 11:09 PM To: [email protected] Subject: Re: [JAWS-Users] Using cross-sheet references in Excel with Jaws
Hello robin, The easiest way to do it is to use the paste special function. Simply copy the cell with the formula in the sheet or workbook being linked to, move to where you want the result to appear in the other workbook or worksheet, and use the paste link command in the paste special dialog box. To do that press Alt-E to bring up the edit menu. Use down arrow to move to the "paste special" choice and press enter. Use Alt-L to activate the "paste link" choice. The formula will now be linked to the cell you copied in the other workbook or worksheet and will change when the original one changes. You can write the formula in the second workbook or worksheet by using opening single quotation marks around the workbook and worksheet names, but if there are spaces in the worksheet name then you will have to use square brackets as well, there will be an exclamation mark necessary and you will need to use absolute references. If you need a lesson on this subject I can send you one off list. However, I think the use of the paste link function is the easiest for you to use. Take care. Brian Lee [EMAIL PROTECTED] ----- Original Message ----- From: "Williams, Robin" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 05, 2008 4:40 AM Subject: [JAWS-Users] Using cross-sheet references in Excel with Jaws > Hi all, > I need to use a cross-sheet reference in Excel for some work I am > doing. I.e. I am in a worksheet, and need to use data from another > worksheet (actually another workbook i.e. a separate file) in my > formulae. > Now according to the Jaws Help for Excel, under Miscelaneous hints, I > can apparently press equals (=) in the cell in which I want to produce > the formula, navigate to the appropriate place in the other file, select > the relevant cells, etc, which sounds fine. > However when I press equals, and go to open another file, pressing > ctrl+o does nothing and indeed the open option is unavailable in the > file menu. I have tried long and hard to solve this and have got > nowhere, am I just making a simple mistake? How can I navigate to the > file I need when entering a formula? > I am using Jaws 9.0 with Excel2003. > Many thanks for any help. > > > Robin Williams > Met Office summer intern - Health Forecasting > [EMAIL PROTECTED] > > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Visit the Blind Computing home page at: > http://www.blind-computing.com > Address for the list archives: > http://www.mail-archive.com/[email protected] > To post to this group, send email to > [email protected] > To unsubscribe from this group, send an email to > [EMAIL PROTECTED] > For help from Mailman with your account Put the word help in the subject > or body of a blank message to: > [EMAIL PROTECTED] > Use the following form in order to contact the management team > http://www.jaws-users.com/managers.php > If you wish to join the Blind Computing list send a blank email to the > following address: > [EMAIL PROTECTED] > Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED] Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED]
