Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer info from one sheet to another?
I want to transfer certain cells from one sheet into another sheet. I can
not get the cell to work. I keep getting a error message. Could you please tell me how to take the info form sheet 2 A3 and have it automatically transfer into sheet one colum A? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer info from one sheet to another?
Try the following formula in Sheet1 column A
=(Sheet2!A3) -- Richard "Teresa" wrote: I want to transfer certain cells from one sheet into another sheet. I can not get the cell to work. I keep getting a error message. Could you please tell me how to take the info form sheet 2 A3 and have it automatically transfer into sheet one colum A? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer info from one sheet to another?
In Sheet1, enter:
=Sheet2!A3 HTH -- AP "Teresa" a écrit dans le message de news: ... I want to transfer certain cells from one sheet into another sheet. I can not get the cell to work. I keep getting a error message. Could you please tell me how to take the info form sheet 2 A3 and have it automatically transfer into sheet one colum A? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer info from one sheet to another?
Hi Richard,
No that didn't work it gave me this message #REF. I have multiple sheets that I need to carry certain information over to sheet one and keep getting various errors. "Richard" wrote: Try the following formula in Sheet1 column A =(Sheet2!A3) -- Richard "Teresa" wrote: I want to transfer certain cells from one sheet into another sheet. I can not get the cell to work. I keep getting a error message. Could you please tell me how to take the info form sheet 2 A3 and have it automatically transfer into sheet one colum A? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer info from one sheet to another?
Try ='[Workbookname.xls]Sheet1'!A1
where Workbookname.xls is the name of your file, Sheet1 is the name of the worksheet in that file and A1 is the cell in the specified worksheet. -- Kevin Backmann "Teresa" wrote: Hi Richard, No that didn't work it gave me this message #REF. I have multiple sheets that I need to carry certain information over to sheet one and keep getting various errors. "Richard" wrote: Try the following formula in Sheet1 column A =(Sheet2!A3) -- Richard "Teresa" wrote: I want to transfer certain cells from one sheet into another sheet. I can not get the cell to work. I keep getting a error message. Could you please tell me how to take the info form sheet 2 A3 and have it automatically transfer into sheet one colum A? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer info from one sheet to another?
Hi Teresa
I'm sorry that didn't work. Another way to link cells/sheets is: Click a cell in Sheet1 Click on the = sign under your toolbar Click the sheet tab at the bottom of the screen you want to link Sheet1 to Click the cell in the sheet you want to link to Click OK Hope this helps. Richard "Teresa" wrote: Hi Richard, No that didn't work it gave me this message #REF. I have multiple sheets that I need to carry certain information over to sheet one and keep getting various errors. "Richard" wrote: Try the following formula in Sheet1 column A =(Sheet2!A3) -- Richard "Teresa" wrote: I want to transfer certain cells from one sheet into another sheet. I can not get the cell to work. I keep getting a error message. Could you please tell me how to take the info form sheet 2 A3 and have it automatically transfer into sheet one colum A? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer info from one sheet to another?
One more technique:
Select the "sending" cell edit|Copy Select the "receiving" cell edit|Paste special|click Paste Link Teresa wrote: I want to transfer certain cells from one sheet into another sheet. I can not get the cell to work. I keep getting a error message. Could you please tell me how to take the info form sheet 2 A3 and have it automatically transfer into sheet one colum A? -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer info from one sheet to another?
Are the sheets in the same workbook? If not, are both workbooks open in the
same instance of Excel? "Teresa" wrote: I want to transfer certain cells from one sheet into another sheet. I can not get the cell to work. I keep getting a error message. Could you please tell me how to take the info form sheet 2 A3 and have it automatically transfer into sheet one colum A? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer data from sheet1 to sheet 2 | Excel Worksheet Functions | |||
Master spread sheet to manage then show info on seperate tabs | Excel Worksheet Functions | |||
Transfer From one to another sheet | Excel Worksheet Functions | |||
How do I keep link to info on another sheet if that other sheet i. | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |