Define Name - same name for multiple cells on multiple sheets
 

Hi community:

I've been searching for a while to find an answer to my problem but
couldn't, so here it is:

A B
1 1001 Food Sales Lunch
2 1002 Food Sales Dinner
3 1003 Food Sales Catering
...

I have the same struture of data on another 40 sheets in the same workbook.
I want to name each of the cells A1, A2, A3, ... 'ACCOUNT'.
the same for Sheet2, Sheet3, .... sort of a relative rather than absolute
reference.

So, when using ACCOUNT in a formula in e.g. Sheet1, cell C1, ACCOUNT refers
to cell A1, when using the same name in line 3, it refers to A3 and so on.

thanks a lot in advance!
Thomas

Define Name - same name for multiple cells on multiple sheets
 

This will create a *relative*named*formula*, which will reference Column A,
on the row that it's used in.

It should work in all existing Sheets, PLUS, any additional sheets added
thereafter.

From the Menu Bar of *any* sheet in the WB:
<Insert <Name <Define,

In the "Names In Workbook" box, type:
account

CHANGE whatever's in the "Refers To" box to:
=INDIRECT("A"&ROW())

Then <OK

And you should be done!

Enter a value in Column A.

In any other column, on the same row, enter:
=account
And you'll see that value, or text data.

And you can use it in a formula:
=10*account
=Sum(T5:T12,U13:U20,account,B10)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Thomas" wrote in message
...
Hi community:

I've been searching for a while to find an answer to my problem but
couldn't, so here it is:

A B
1 1001 Food Sales Lunch
2 1002 Food Sales Dinner
3 1003 Food Sales Catering
...

I have the same struture of data on another 40 sheets in the same
workbook.
I want to name each of the cells A1, A2, A3, ... 'ACCOUNT'.
the same for Sheet2, Sheet3, .... sort of a relative rather than absolute
reference.

So, when using ACCOUNT in a formula in e.g. Sheet1, cell C1, ACCOUNT
refers
to cell A1, when using the same name in line 3, it refers to A3 and so on.

thanks a lot in advance!
Thomas

Define Name - same name for multiple cells on multiple sheets
 

that worked like a charm! thx a bunch!!

"RagDyer" wrote:

This will create a *relative*named*formula*, which will reference Column A,
on the row that it's used in.

It should work in all existing Sheets, PLUS, any additional sheets added
thereafter.

From the Menu Bar of *any* sheet in the WB:
<Insert <Name <Define,

In the "Names In Workbook" box, type:
account

CHANGE whatever's in the "Refers To" box to:
=INDIRECT("A"&ROW())

Then <OK

And you should be done!

Enter a value in Column A.

In any other column, on the same row, enter:
=account
And you'll see that value, or text data.

And you can use it in a formula:
=10*account
=Sum(T5:T12,U13:U20,account,B10)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Thomas" wrote in message
...
Hi community:

I've been searching for a while to find an answer to my problem but
couldn't, so here it is:

A B
1 1001 Food Sales Lunch
2 1002 Food Sales Dinner
3 1003 Food Sales Catering
...

I have the same struture of data on another 40 sheets in the same
workbook.
I want to name each of the cells A1, A2, A3, ... 'ACCOUNT'.
the same for Sheet2, Sheet3, .... sort of a relative rather than absolute
reference.

So, when using ACCOUNT in a formula in e.g. Sheet1, cell C1, ACCOUNT
refers
to cell A1, when using the same name in line 3, it refers to A3 and so on.

thanks a lot in advance!
Thomas

Define Name - same name for multiple cells on multiple sheets
 

You're welcome, and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Thomas" wrote in message
...
that worked like a charm! thx a bunch!!

"RagDyer" wrote:

This will create a *relative*named*formula*, which will reference Column
A,
on the row that it's used in.

It should work in all existing Sheets, PLUS, any additional sheets added
thereafter.

From the Menu Bar of *any* sheet in the WB:
<Insert <Name <Define,

In the "Names In Workbook" box, type:
account

CHANGE whatever's in the "Refers To" box to:
=INDIRECT("A"&ROW())

Then <OK

And you should be done!

Enter a value in Column A.

In any other column, on the same row, enter:
=account
And you'll see that value, or text data.

And you can use it in a formula:
=10*account
=Sum(T5:T12,U13:U20,account,B10)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Thomas" wrote in message
...
Hi community:

I've been searching for a while to find an answer to my problem but
couldn't, so here it is:

A B
1 1001 Food Sales Lunch
2 1002 Food Sales Dinner
3 1003 Food Sales Catering
...

I have the same struture of data on another 40 sheets in the same
workbook.
I want to name each of the cells A1, A2, A3, ... 'ACCOUNT'.
the same for Sheet2, Sheet3, .... sort of a relative rather than
absolute
reference.

So, when using ACCOUNT in a formula in e.g. Sheet1, cell C1, ACCOUNT
refers
to cell A1, when using the same name in line 3, it refers to A3 and so
on.

thanks a lot in advance!
Thomas