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.
- Nov 18 Sat 2006 20:10
moving text
close
全站熱搜
留言列表
發表留言