Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
moving text
I want to move names from one worksheet to another by referencing cells. I
know that =SUM moves numbers but I can't get any of the other functions to move a name from Worksheet One cell B4 to Worksheet Two cell D6. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
moving text
You don't need to use a function. Just type = followed by your cell
reference. So for your example, in Cell D6 on Sheet 2 enter the formula: =Sheet1!B4 This will also work with numbers. You only need to use the SUM function when you want to add a range of cells. HTH, Elkar "Golden Knight" wrote: I want to move names from one worksheet to another by referencing cells. I know that =SUM moves numbers but I can't get any of the other functions to move a name from Worksheet One cell B4 to Worksheet Two cell D6. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell text based on 4 condition test | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
moving text | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) |