A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Same cell but different worksheet



 
 
Thread Tools Display Modes
  #1  
Old January 11th, 2010, 01:23 AM posted to microsoft.public.excel.worksheet.functions
mjones
external usenet poster
 
Posts: 81
Default 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  
Old January 11th, 2010, 02:34 AM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default 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  
Old January 11th, 2010, 02:43 AM posted to microsoft.public.excel.worksheet.functions
mjones
external usenet poster
 
Posts: 81
Default 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  
Old January 11th, 2010, 02:47 AM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.