Log In
Register
Home
Excel Expert
Power Query
July 14, 2022
Offline
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
See Answer
Trusted Members
Moderators
November 1, 2018
Offline
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.
Answers Post
1 Guest(s)
