Young Grasshopper
Board Regular
- Joined
- Dec 9, 2022
- Messages
- 58
- Office Version
- 365
- 2016
- Platform
- Windows
Another day, another problem!
I have this code in C5: =IF('Sheet1'!B11="";"";'Sheet1'!$B11)
I need to drag C5:G5 horizontally, so this could would be copied to every 5th column, but the reference cells must increase by one vertically every time.
Like this:
C5: =IF('Sheet1'!B11="";"";'Sheet1'!$B11)
H5: =IF('Sheet1'!B12="";"";'Sheet1'!$B12)
M5: =IF('Sheet1'!B13="";"";'Sheet1'!$B13)
etc.
How would I go about this?
Would appreciate any help
I have this code in C5: =IF('Sheet1'!B11="";"";'Sheet1'!$B11)
I need to drag C5:G5 horizontally, so this could would be copied to every 5th column, but the reference cells must increase by one vertically every time.
Like this:
C5: =IF('Sheet1'!B11="";"";'Sheet1'!$B11)
H5: =IF('Sheet1'!B12="";"";'Sheet1'!$B12)
M5: =IF('Sheet1'!B13="";"";'Sheet1'!$B13)
etc.
How would I go about this?
Would appreciate any help