Absolute Referencing

[bullcreel]

I have 'bat calcs'!$BA64 in cell BY17. I am trying to copy/paste into cell FA17 and then it should read 'bat calcs'!$BA65, with the absolute referencing, however, it is staying 'bat calcs'!$BA64.
Thanks in advance.

 

[bullcreel]

Understand. What I do with my spreadsheet is develop baseball cards for a table top baseball game that uses dice. The bat calcs sheet has all the players and data that I am pulling data from. The sheet that needs the data has 9 baseball cards in 3 rows. So thats why I cant use the normal logic.
Thanks for the explanation. I was hoping there was a way. I will continue to copy over and then change row for each card.

 

[Joe4]

Understand. What I do with my spreadsheet is develop baseball cards for a table top baseball game that uses dice. The bat calcs sheet has all the players and data that I am pulling data from. The sheet that needs the data has 9 baseball cards in 3 rows. So thats why I cant use the normal logic.
Thanks for the explanation. I was hoping there was a way. I will continue to copy over and then change row for each card.

You could probably use VBA to populate all those formulas for you based on your logic.