I have 2 columns which will more or less repeat again and again but the cells
are linked to columns in another worksheet. Basically, I'm having to copy
and paste my first 2 columns, go into each cells formulas and change the
Letter and the Number of the cell it is linked to (in the formula). Excel
automatically goes one up on the Letter but in the wrong direction and it
doesn't go one up in the Number.

It's hard to explain but is there an easy way to dictate what intervals go
up within the formula's reference to the linked cells - in what increments?