I need a way to copy a formula across a row but reference cells moving down a column in another sheet. I used absolute cell references to keep the column consistent but I still have to manually adjust the formulas when I copy them across the row.
Solved by F. W. in 23 mins