Hi all, quick question for my clever Excel friends.
Imagine I have a formula in worksheet A, on row 1 that references a cell in another worksheet B, row 1.
Row 2 on worksheet A needs to reference a cell on row 21 in worksheet B.
Row 3 on worksheet A needs to reference a call on row 41 on worksheet B.
And so on.
I'm sure there's a way to make Excel 365 fill down in increments of 20 (in this example), but i can't find it.
Could someone point me in the right direction please?
Thanks in advance
Rod
Let's say the other sheet is named Other Sheet. In A1 enter:
zz'Other Sheet'!B1
In A2 enter:
zz'Other Sheet'!B21
Then select A1 and A2, and fill down as far as necessary (it will increment to zz'Other Sheet1B41 and so on). Then press Ctrl+H (for the Find/Replace dialog, and replace zz with = to convert them to formulas.
ooooo!!!!! - thank you soo much. I love a lateral approach that works, that is going to save me so much time
