Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Info from cell to another sheet
I just had the biggest brain fart. I have a worksheet I am trying to copy
all of the data from one to the other using a formula. The work sheet with the data is called one where the one that I am trying to write a formula to copy it to is two. When I do sum it makes the name 0. Example below Thank you Ex A B C D 1 0012 Bob Tiffany 2 0026 Brandy Frank 3 4 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Info from cell to another sheet
On sheet "two" cell A1, enter the formula:
=one!A1 This will return the contents of cell A1 on the sheet called "one". Note that this is not the same as "Copying", as any changes made to sheet one will automatically be reflected on sheet two. Is that what you're looking for? HTH, Elkar "Jeremy" wrote: I just had the biggest brain fart. I have a worksheet I am trying to copy all of the data from one to the other using a formula. The work sheet with the data is called one where the one that I am trying to write a formula to copy it to is two. When I do sum it makes the name 0. Example below Thank you Ex A B C D 1 0012 Bob Tiffany 2 0026 Brandy Frank 3 4 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Info from cell to another sheet
Perfect thank you
"Elkar" wrote: On sheet "two" cell A1, enter the formula: =one!A1 This will return the contents of cell A1 on the sheet called "one". Note that this is not the same as "Copying", as any changes made to sheet one will automatically be reflected on sheet two. Is that what you're looking for? HTH, Elkar "Jeremy" wrote: I just had the biggest brain fart. I have a worksheet I am trying to copy all of the data from one to the other using a formula. The work sheet with the data is called one where the one that I am trying to write a formula to copy it to is two. When I do sum it makes the name 0. Example below Thank you Ex A B C D 1 0012 Bob Tiffany 2 0026 Brandy Frank 3 4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop Macro a variable number of times | Excel Discussion (Misc queries) | |||
Linking worksheets | Excel Worksheet Functions | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |