microsoft excel – Increment Column Number in Fill Series down the row

Is there a way to increment column number using fill series functionality?

Example: I want to make the forumla in row n to :

='DPA Codes'!BA2 (in row n) —— to ——- ='DPA Codes'!BB2 (in row n+1, same column)

currently Excel would make the next row cell as ='DPA Codes'!BA3

i.e. it incremented the row number from 2 to 3, but I require the column BA to become BB

Column Snippet