Forum Discussion
Non-Consecutive Cell Referencing
Thank you also for your help. I will stick to your proposal for the reasons you give. But I will play around with all suggestions just to get an idea of how and why these functions work. Have a Merry Xmas!
You can do this with a simple formula, no INDIRECT needed.
In B3, use:
='Orig'!A3
In B8, use:
='Orig'!A4
The trick is to automate that pattern. Put this formula in B3 and copy it down:
='Orig'!A3+INT((ROW()-ROW($B$3))/5)
This makes the source cell move down by 1 in Orig every 5 rows in column B.
Simple, clean, and beginner-friendly.
maybe i'm missing something but
='Orig'!A3+INT((ROW()-ROW($B$3))/5)
will just ADD numbers to the VALUE in A3 and if you intended to copy that to every 5th cell then A3 would change also so you may have meant to use $A$3 (or at least A$3) but either way don't see that working
sry