no problem......anytime!!!



"i2meek" wrote in message
...
yes - my values go to 31 BUT i only named the 1st 2 worksheets the same
and
just used #'s for the rest, planning to name them later - i'll give them
the
same name and see what happens, that's probably it - your good
Thanks a million

"Conan Kelly" wrote:

In your helper column do your values go from 1 to 31 or do they go from 1
to
2? If they only go to "2", copy "2" down until the value is "31".

Also, check the spelling of all of the sheet names in "Data.xlsx". This
solution will only work if they are all named consistently: the word
"Game", a space, and then the game number. For Example:

Game 1
Game 2
Game 3
...
...
...
Game 29
Game 30
Game 31

FYI, I've never used XL 2007.....don't know anything about it. My
answers
are based on my knowledge of XL 2002-2003. My success at helping you
through this depends on how compatible they are.





"i2meek" wrote in message
...
(By the way - i'm using excel 2007 and will later probably save as
excel
97-03)

Worked in the cell I typed it in. I then selected some cells in the
column,
went to editing and chose fill down. It worked in the cell directly
below,
but the rest gave the #REF. ???

"Conan Kelly" wrote:

Oooppss!!!

change the formula from:

=INDIRECT("='[Data.xlsx]Game " & $Z2 & "'!E4")

to:

=INDIRECT("'[Data.xlsx]Game " & $Z2 & "'!E4")

(take out the second "=")

Sorry.

See if that will work



"i2meek" wrote in message
...
I got: #REF! in the cell -

It appears as though we are "manually" forcing the number to
increase
by
1,
rather than having the cell paset-linked directly. I've noticed in
the
past
that when I keyboard in a paste-link formula correctly it doesn't
work,
but
when I paste-link it, it does. Why? Is there some setting I need to
change?

"Conan Kelly" wrote:

i2meek,

Excel doesn't work that way. It will change the "E4" to "E5" when
copying/filling down.

In order to do this you will need to use the INDIRECT() function
(and
maybe
a helper column)

I'm going to assume that row 1 is your lables and your data starts
in
row
2
I'm going to use column Z as a helper column (this helper column
can
be
hidden so you don't see it).

1. In Z2 enter a "1" (w/o quotes)
2. In Z3 enter "=Z2+1" (w/o quotes)
3. Copy Z3 down until the value is "31"
4. In the cell that has your fomula "='[Data.xlsx]Game 1'!E4",
change
it
to:

=INDIRECT("='[Data.xlsx]Game " & $Z2 & "'!E4")

Now if you do it this way, copying/filling down should get the
results
you
are looking for, I THINK!!! (have not tested it)

BUT, if you need to copy/fill accross, this formula will NOT change
"E4"
to
"F4". It will take some more work to get it to do that.

If you want to do this with out the helper column, it can be done,
but
I
need more info from you. What cells are your lables? What cells
do
you
want your data to be in?

HTH,

Conan




"i2meek" wrote in message
...
In the formula below, I want the number 1 to then increase by one
in
the
column directly below, all the way to number 31
Player 1 stat in first row:
='[Data.xlsx]Game 1'!E4

last entry in column:
='[Data.xlsx]Game31'!E4


"i2meek" wrote:

I am making a basketball stats program.

I have a workbook where data is entered. In this workbook there
are
31
worksheets, one for data to be entered for each game. The 31
worksheets
have
all 23 players' names down 2 columns on the left, and all the
stat
headings
across the top row.

I have another workbook that displays player stats with
calculations
and
has
23 worksheets, one for each player. It has the 31 games listed
in
a
column
on the left and the stat headings across the top.

I would like to link paste-link the data in worksheet1, row1 to
the
player 1
stat row1. The data in worksheet 1 row 2 to the player2 stat
row1,
Worksheet1 row3 to player3 row1, etc. Then after game 2,
paste-link
the
data
in worksheet2 row1 to player1 row2, worksheet2 row2 to player2
row2,
worksheet2 row3, to player3 row2 etc.

I thought I could do the first paste-link and then fill down.
However,
when
I do this, the cell location does not increase by 1. What is
the
quickest
way to do this?