Increment text field in excel formula
Posted on 2012-03-30
I have an Excel workbook that I use to track the achievements of my Cub Scout pack. One of the sheets is outdated, and the original creator is deceased, so I took it upon myself to update it.
I am using the following formula:
=INDIRECT("Beltloops!" & $A$3 & "11")
On each individual scout worksheet to track entries made to the master worksheet. The problem I have now is that there are over 200 cells that need to be changed from a direct cell reference to the formula above, on 15 worksheets. Is there any way I can automate incrementing the text field (11 in my example) the same way the numbers increase when I drag and copy a cell with a number or a formula?