cell drop and drag

D

D Snider

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.
 
P

Peo Sjoblom

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
 
Top