This is another building block for formatting a large spread sheet I have to use, thanks in advance!
I need to use a cell value as a column offset, move right the corresponding offset, then write a "1" in the next 5 columns of that row.
Then repeat for the rest of the rows in my sheet.
<tbody>
</tbody>
I need to use a cell value as a column offset, move right the corresponding offset, then write a "1" in the next 5 columns of that row.
Then repeat for the rest of the rows in my sheet.
Offset | ||||||||
1 | 1 | 1 | 1 | 1 | 1 | |||
2 | 1 | 1 | 1 | 1 | 1 | |||
3 | 1 | 1 | 1 | 1 | 1 | |||
4 | 1 | 1 | 1 | 1 | 1 |
<tbody>
</tbody>