close

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.

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

quot;Golden Knightquot; wrote:

gt; I want to move names from one worksheet to another by referencing cells. I
gt; know that =SUM moves numbers but I can't get any of the other functions to
gt; move a name from Worksheet One cell B4 to Worksheet Two cell D6.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()