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.
Thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Absolute Referencing
- Thread starter bullcreel
- Start date
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.
Thanks for the explanation. I was hoping there was a way. I will continue to copy over and then change row for each card.
Upvote
0
Excel Facts
Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Similar threads
- Solved
