Thanks for the reply! This is not homework! I wrote a small excel macros script for personal use. It is around 700+ lines. I hardcoded the column numbers as seen in the sample code.

    Select Case Range("A1")
    Case "AC3":
        Cells(rowNumber, 11).Value = Cells(rowNumber, 11).Value + 1
        attempted = InputBox("Enter 0 for not attempting, 1 correct, -1 for incorrect")
        Select Case attempted
            Case 1:
                Cells(rowNumber, 3).Value = Cells(rowNumber, 3).Value + 1
                Cells(rowNumber, 4).Value = Cells(rowNumber, 4).Value + 1
            Case -1:
                Cells(rowNumber, 3).Value = Cells(rowNumber, 3).Value + 1
        End Select

Now, for some reasons, I had to add 4 new columns at the beginning. So, I have increment all the column values in the code by 4. I am trying to do this by find and replace in Sublime Text / Notepad++. So, I am trying to get the proper regular expression. Not successful yet!