If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying Data in a cell in one sheet to a cell in another sheet
I've run into a problem trying to copy data from a cell
in one sheet to another. I have a spreadsheet called "rating" which contains a number of formula that calculates a final number. I also have a spreadsheet called "Final" that copies over the information from "Rating". In "Final", I'm trying to copy a number from "Rating" into a particular cell. I put in =Rating! G89, but it won't work. When I press enter, a window pops up "Update value:Rating". I press enter again and in the cell where I want the number to appear, #name? appears. Can you tell me where I went wrong? I've followed the same process in other cells in "Final" and it works fine. It's just this one cell that gives me a problem. Thanks for your help! |
#2
|
|||
|
|||
Copying Data in a cell in one sheet to a cell in another sheet
Try
=[Rating.xls]Sheet1!$G$89 Charlie O'Neill -----Original Message----- I've run into a problem trying to copy data from a cell in one sheet to another. I have a spreadsheet called "rating" which contains a number of formula that calculates a final number. I also have a spreadsheet called "Final" that copies over the information from "Rating". In "Final", I'm trying to copy a number from "Rating" into a particular cell. I put in =Rating! G89, but it won't work. When I press enter, a window pops up "Update value:Rating". I press enter again and in the cell where I want the number to appear, #name? appears. Can you tell me where I went wrong? I've followed the same process in other cells in "Final" and it works fine. It's just this one cell that gives me a problem. Thanks for your help! . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restricting cell data to unique entries? | Jones | General Discussion | 11 | June 23rd, 2004 04:05 PM |
data sheet to indie worksheets | Dave R. | Worksheet Functions | 2 | May 19th, 2004 06:11 PM |
Relative transfer of data from the last sheet | Mahendra | Worksheet Functions | 2 | February 13th, 2004 04:10 PM |
HELP! Return data if cell in row contains data | dee | Worksheet Functions | 13 | November 10th, 2003 06:48 PM |
Dropdown Box to Select Data from Another Sheet | Annabelle | Worksheet Functions | 2 | November 10th, 2003 03:39 PM |