#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Please Help

Hi,

I posted a couple days ago in the general questions board on name mirroring.
I've been searching for 3 days now, and any help would be appreciated.

All I want to do is reference text in one cell on one page to text in
another cell on another page.

That way if I change the wording on one tab, it changes the wording for all
the corresponding tabs that I correlate.

Thanks,

Dustin

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,942
Default Please Help

hi
a formula should do it.
if you have text in say A1 on sheet 1and want the same text in A1 on sheet 2
then
on sheet 2 cell A1 put....
=sheet1!A1
this will pull the text in sheet 1 cell A1 into sheet 2 cell A1. if the text
is change in sheet 1 cell A1, the text in sheet 2 cell A1 will change.

hope this helps
Regards
FSt1

"Dust10b" wrote:

Hi,

I posted a couple days ago in the general questions board on name mirroring.
I've been searching for 3 days now, and any help would be appreciated.

All I want to do is reference text in one cell on one page to text in
another cell on another page.

That way if I change the wording on one tab, it changes the wording for all
the corresponding tabs that I correlate.

Thanks,

Dustin

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Please Help

Thank you, you are my hero. Seriously this was difficult for me.

"FSt1" wrote:

hi
a formula should do it.
if you have text in say A1 on sheet 1and want the same text in A1 on sheet 2
then
on sheet 2 cell A1 put....
=sheet1!A1
this will pull the text in sheet 1 cell A1 into sheet 2 cell A1. if the text
is change in sheet 1 cell A1, the text in sheet 2 cell A1 will change.

hope this helps
Regards
FSt1

"Dust10b" wrote:

Hi,

I posted a couple days ago in the general questions board on name mirroring.
I've been searching for 3 days now, and any help would be appreciated.

All I want to do is reference text in one cell on one page to text in
another cell on another page.

That way if I change the wording on one tab, it changes the wording for all
the corresponding tabs that I correlate.

Thanks,

Dustin

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default Please Help

Just select the sheets desired by holding down the ctrl key and touching the
tab of desired sheetschange in one changes in ALLselect any sheet to stop
this action.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dust10b" wrote in message
...
Hi,

I posted a couple days ago in the general questions board on name
mirroring.
I've been searching for 3 days now, and any help would be appreciated.

All I want to do is reference text in one cell on one page to text in
another cell on another page.

That way if I change the wording on one tab, it changes the wording for
all
the corresponding tabs that I correlate.

Thanks,

Dustin


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:54 AM.

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

About Us

"It's about Microsoft Excel"