Let's say I have two worksheets. Each has a specific name, i.e. Person 1 &
Person 2.

In the first Worksheet, I want a heading. The heading should match the
tab's name, i.e. A1 would have a formula that would show "Person 1". So that
if the Tab name were to change, the formula would also reflect the change.

I know that there are codes for headers, i.e. &Tab. Is there a
function/formula out there that I can use?

See

Worksheet and Workbook names using the CELL() function
http://www.mcgimpsey.com/excel/formu..._function.html

or

Changing Sheet Name to match cell, automatically
http://www.mcgimpsey.com/excel/event...efromcell.html


In article ,
"Charles Rodriguez"
wrote:

Let's say I have two worksheets. Each has a specific name, i.e. Person 1 &
Person 2.

In the first Worksheet, I want a heading. The heading should match the
tab's name, i.e. A1 would have a formula that would show "Person 1". So that
if the Tab name were to change, the formula would also reflect the change.

I know that there are codes for headers, i.e. &Tab. Is there a
function/formula out there that I can use?

Thank you JE McGimpsey!!! Worked perfectly! Why didn't Excel's Help have
that?!

Thanks again!

"JE McGimpsey" wrote:

See

Worksheet and Workbook names using the CELL() function
http://www.mcgimpsey.com/excel/formu..._function.html

or

Changing Sheet Name to match cell, automatically
http://www.mcgimpsey.com/excel/event...efromcell.html


In article ,
"Charles Rodriguez"
wrote:

Let's say I have two worksheets. Each has a specific name, i.e. Person 1 &
Person 2.

In the first Worksheet, I want a heading. The heading should match the
tab's name, i.e. A1 would have a formula that would show "Person 1". So that
if the Tab name were to change, the formula would also reflect the change.

I know that there are codes for headers, i.e. &Tab. Is there a
function/formula out there that I can use?

I tried to use the macro that would take the value in a cell and change the
tab name. It didn't work for me. I don't think I understood fully as to
where to put the code and how to activate it. The screen shots have the
Apple version, I'm using Windows XP, Office 2003.

I clicked on additional link on right, "where to put macros", but I didn't
find it clear enough to follow.

"JE McGimpsey" wrote:

See

Worksheet and Workbook names using the CELL() function
http://www.mcgimpsey.com/excel/formu..._function.html

or

Changing Sheet Name to match cell, automatically
http://www.mcgimpsey.com/excel/event...efromcell.html


In article ,
"Charles Rodriguez"
wrote:

Let's say I have two worksheets. Each has a specific name, i.e. Person 1 &
Person 2.

In the first Worksheet, I want a heading. The heading should match the
tab's name, i.e. A1 would have a formula that would show "Person 1". So that
if the Tab name were to change, the formula would also reflect the change.

I know that there are codes for headers, i.e. &Tab. Is there a
function/formula out there that I can use?

In article ,
"Charles Rodriguez"
wrote:

I tried to use the macro that would take the value in a cell and change the
tab name. It didn't work for me. I don't think I understood fully as to
where to put the code and how to activate it. The screen shots have the
Apple version, I'm using Windows XP, Office 2003.

It really isn't that different, but you can see a WinXL description he

http://cpearson.com/excel/codemods.htm

If you don't see the Project Browser when you open the VBE, choose
View/Project Browser.

I clicked on additional link on right, "where to put macros", but I didn't
find it clear enough to follow.

Constructive criticism is welcome, if you can let me know what needs to
be improved.