After, i created the name i go and change just the team # or Player #
Yan!

"Gord Dibben" wrote:

Don't understand your request.

If you want same name same cell all sheets, how will you distinguish which
player you are referring to on which sheet?

Gord

On Thu, 21 Sep 2006 07:47:01 -0700, Yan wrote:

I know but what i am trying to do is to name same cell same name in 26 sheets
cause, i am doing a DARTS SCORE program and need to refer to those cells,
for different players

I take is score from his sheet, and value it in another main sheet!

"Gord Dibben" wrote:

Try this.

On any sheet go to InsertNameDefine.

Type in a name like thecell

In the "refers to:" box enter =!$A$1 and OK

On any sheet F5 and type in "thecell"(no quotes) to go to A1 on that sheet.

Or use thecell in a formula on any sheet.


Gord Dibben MS Excel MVP

On Wed, 20 Sep 2006 13:51:02 -0700, Yan Cossette <Yan
wrote:

How to give same name to a cell in multiple sheets at the same time

I did try to group all the sheet at the sametime and name the cell, but it
did not work, each of my sheet have different name?

Need Help!



Gord Dibben MS Excel MVP