 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2008Attempting to link cells failing.
This will be an easy one for you experts. A sheet is called "WK1 1-4apr". At the bottom it has some countif formulas. N404 is one of these. Naturally, the only thing visible in the cell is the correctly functioning result. In another sheet, "sheet1", I want to gather up the results from the countifs in various sheets. Therefore I use the link option. Or rather, I try to. I click on WK1 1-4apr cell N404. Click the copy button, the maquis appears. (Spelling?!:) Go to sheet 1. Click on the cell I want to display the result in N404. Click on the paste button. Now, I SHOULD get the result of N404 showing with a list of options, of which I should click "Link cells". I actually get either a file browse box, or the countif formula from N404 showing with a circular reference. Huh? Can anyone advise what I might be doing wrong in order to get a result like this? I've tried typing the formula by hand. Also using keyboard shortcuts instead of buttons. Thanks. Baffled of Cyberspace. Start with the cursor in the cell in Sheet1 where you want the result to show. Then type = and then click to the sheet where the formula is, navigate down to N404 and select that cell, and then press <enter>. You should have the result showing in the cell you first selected, and if you select it again you should see in the formula bar: ='WK1 1-4apr'!N404 i.e. you have the sheet name within apostrophes (because you have spaces in the name) followed by ! and then followed by the cell reference on that sheet. In future you could just type the formula yourself, but it is easier to let Excel work out the syntax for you. Now if the value of N404 changes, it will be reflected immediately in the cell on Sheet1. Hope this helps. Pete On Jul 30, 11:03 pm, Mike Barnard <m.barnard.trous...@thunderin.co.uk> wrote: > This will be an easy one for you experts. > [quoted text clipped - 24 lines] > > Baffled of Cyberspace. It's easier if one select the source cell, copy it, then select where one wants the link and paste special and select paste link. It seems that's what the OP tried but failed. He should select the down arrow when clicking the paste button and then paste special>paste link. Or right click and then select paste special>paste link or finally edit>paste special>paste link  SignatureRegards, Peo Sjoblom Start with the cursor in the cell in Sheet1 where you want the result to show. Then type = and then click to the sheet where the formula is, navigate down to N404 and select that cell, and then press <enter>. You should have the result showing in the cell you first selected, and if you select it again you should see in the formula bar: ='WK1 1-4apr'!N404 i.e. you have the sheet name within apostrophes (because you have spaces in the name) followed by ! and then followed by the cell reference on that sheet. In future you could just type the formula yourself, but it is easier to let Excel work out the syntax for you. Now if the value of N404 changes, it will be reflected immediately in the cell on Sheet1. Hope this helps. Pete On Jul 30, 11:03 pm, Mike Barnard <m.barnard.trous...@thunderin.co.uk> wrote: > This will be an easy one for you experts. > [quoted text clipped - 24 lines] > > Baffled of Cyberspace. >It's easier if one select the source cell, copy it, then select >where one wants the link and paste special and select paste link. >It seems that's what the OP tried but failed. He should >select the down arrow when clicking the paste button and then paste >special>paste link. Or right click and then select paste special>paste link >or finally edit>paste special>paste link What causes it to bring up that file browser box! Arggh. >Start with the cursor in the cell in Sheet1 where you want the result >to show. Then type = and then click to the sheet where the formula is, [quoted text clipped - 15 lines] > >Pete Thanks, but it's often failing. I just don't know why. >On Jul 30, 11:03 pm, Mike Barnard <m.barnard.trous...@thunderin.co.uk> >wrote: [quoted text clipped - 26 lines] >> >> Baffled of Cyberspace. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.