I have the following formula
=IF('Sheet1'!B6<>"",'Sheet1'!B6,"")
I need to copy it across roughly 200 rows but I need the cell reference row to increment by 4 each row.
End of result would be a series of rows that look like:
=IF('Sheet1'!B6<>"",'Sheet1'!B6,"")
=IF('Sheet1'!B10<>"",'Sheet1'!B10,"")
=IF('Sheet1'!B14<>"",'Sheet1'!B14,"")
=IF('Sheet1'!B18<>"",'Sheet1'!B18,"")
=IF('Sheet1'!B22<>"",'Sheet1'!B22,"")
Thoughts?
Bookmarks