cell drop and drag

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drag Down Formula Incorrect 3
Games I've been playing lately and the state of things Chez Flops 3
Auto fill Cells with text 2
sorting grouped cells 1
Working with arrays as arguments 6
How do I tell Excel to insert data from a cell 4 to the left? 1
SUMIF with OFFSET 5
Steam Play For Linux Now Runs Windows-Exclusive Games !!!!!!! 7

Back
Top