Hi.
I'm wanting to copy a formula down a column following a pattern, but obviously just by dragging the formula down the cells underneath doesn't work.
Ive seen a few examples but I'm struggling to understand them.
Essentially I want the sequence to be as follows:
='Sheet1'!A1
='Sheet1'!A3...