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
i.e. it incremented the row number from 2 to 3, but I require the column BA to become BB