Let's assume you have these named cells:

T1WK1 refers to Sheet1!A1
T2WK1 refers to Sheet2!A1

To pull these cells into your summary sheet:

=INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A))

When you copy down the formula will evaluate to:

=T1WK1
=T2WK1

When you copy across the formula will evaluate to:

=T1WK1.........=T1WK2
=T2WK1.........=T2WK2

That's what you wanted isn't it? That's how I interpreted it.

Biff

"Yan" wrote in message
...
How do i insert i to reflect my colums

Ok heres one of the colums i got

sheet1 ( B5=T1wk1 )
So how do i make it change eveyrtime with that formulas

Yan

"Biff" wrote:

Hi!

As far as naming the cells en masse, I don't know how to do that. You
might
be able to do it using VBA code but I don't know how.

As far as copying those names (once you get them created):

=INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A))

Just copy across then down.

Biff

"Yan" wrote in message
...
I make a DARTS scoring workbook with 26 Teams, each Teams as is own
sheet,

So every week i enter the scores on each sheet, then using a namecell,
i
copy to the master sheet....

What i need to do, since i have many teams and many week to enter.

On each sheet, i need to enter and name 26 cell diiferently.
EX: A1=T1WK1 - A2=T1WK2 AND SO ON!

As you see the naming is almost the same but only the week # Change up
to
25
weeks, and on the other same thing with T# change to the team number..

I will like to know, if their a way to enter a formulas or something to
do
it automatically.

And on my master sheet, if it possible that when i copy the cell name,
it
change it to the proper team and week at the same time...

Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1,
then
when i copy it to the next column do the following A1=T1WK1 -
B1=T1WK2 -
C1
=T1WK3.......AN SO ON!


THX You!

Yan