I have a formula that refers to an absolute row of cells but the columns are
relative and change one at a time. I want to paste these formulas into
another worksheet where the formula is applied to every other cell in a
constant row.

Currently when I copy and paste the formulas they'll look something like
this:

Into Worksheet 2 A200, I want to insert this formula
=Worksheet 1 !A $203.

Into Worksheet 2 F200, I want to insert this formula
=Worksheet 1 !B$203

Right now I'm getting a relative column reference but its calculating the
column distance from Worksheet 2 cell references and incorporating those into
the copied formula

Is there any way to copy and paste the formulas in an easier manner than
jumping from cell to cell and changing the column reference in the copied
formula?

Thanks!