cell drop and drag
 

I am trying to copy the function +'game (1)'!e9 by using the drop and
drag function. But instead of the advancing the cell number when dragging
down a column I want the game number to advance. So the cell below the
function will read +' game (2)'!e9 , then below that +'game (3)'!e9 ,
etc.... Game data is entered into a game sheet and I want the info form each
game to be automatically entered into the individual player's stat sheet
broken down by game.

Nothing built in but can be done with formulas

=INDIRECT("'game ("&ROW(1:1)&")'!E9")

would be the same as 'game (1)'!E9

E9 will stay the same but the game sheet numbers will increment
I don't know if you have a space between game and the first parens but I put
one there, if not remove the space there

--
Regards,

Peo Sjoblom


"D Snider" <D wrote in message
...
I am trying to copy the function +'game (1)'!e9 by using the drop and
drag function. But instead of the advancing the cell number when dragging
down a column I want the game number to advance. So the cell below the
function will read +' game (2)'!e9 , then below that +'game (3)'!e9
,
etc.... Game data is entered into a game sheet and I want the info form
each
game to be automatically entered into the individual player's stat sheet
broken down by game.