If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Same cell but different worksheet
Hi All,
Can I make a cell the same as the cell, but in a different worksheet. It's a text field. For example A1 in worksheet Marketing Report should be the same as A1 in worksheet Students. Thanks, Michele |
#2
|
|||
|
|||
Same cell but different worksheet
Like this
=Students!a1 The simplest way to do this is to let Excel create the cell address: Type = (don't hit enter) Now navigate to the cell you want "the same" (ie, click on the worksheet tab, click on the cell) Hit Enter You will see that Excel has created the formula for you. Once you learn this, you'll never type a cell address again. Regards, Fred "mjones" wrote in message ... Hi All, Can I make a cell the same as the cell, but in a different worksheet. It's a text field. For example A1 in worksheet Marketing Report should be the same as A1 in worksheet Students. Thanks, Michele |
#3
|
|||
|
|||
Same cell but different worksheet
On Jan 10, 8:34*pm, "Fred Smith" wrote:
Like this =Students!a1 The simplest way to do this is to let Excel create the cell address: Type = (don't hit enter) Now navigate to the cell you want "the same" (ie, click on the worksheet tab, click on the cell) Hit Enter You will see that Excel has created the formula for you. Once you learn this, you'll never type a cell address again. Regards, Fred "mjones" wrote in message ... Hi All, Can I make a cell the same as the cell, but in a different worksheet. It's a text field. For example A1 in worksheet Marketing Report should be the same as A1 in worksheet Students. Thanks, Michele Thanks a bunch. I should have thought of that. |
#4
|
|||
|
|||
Same cell but different worksheet
Just to add another way...
I like to select the cell on the "sending" sheet. Edit|copy Then go to the "receiving" cell. Edit|paste special|paste link And I'd end up with that same formula: =Students!A1 You'll find that if A1 on the Students worksheet is empty, then you'll see a 0 in the receiving cell. You can stop that by modifying the formula: =if(students!a1="","",students!a1) mjones wrote: Hi All, Can I make a cell the same as the cell, but in a different worksheet. It's a text field. For example A1 in worksheet Marketing Report should be the same as A1 in worksheet Students. Thanks, Michele -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|