Hello people,
I'm stuck with a spreadsheet I'm trying to do.
I've put it in place for someone else who is even worse at computers than me, Columns C,E,G etc... (alternate columns) all update automatically to a certain extent.
I'm up to row 38 at the minute I want/need
If Column "A" includes a name I want those alternate columns to be dragged down to the row, so that the formula's above are dragged down allowing the formula to work
If you get what I mean
<tbody>
</tbody>
Basically ^^ If John or any other name is written into A. ... the Date Renewal Column drags down, but only to the column where a name is included... is this possible, thanks in advance
I'm stuck with a spreadsheet I'm trying to do.
I've put it in place for someone else who is even worse at computers than me, Columns C,E,G etc... (alternate columns) all update automatically to a certain extent.
I'm up to row 38 at the minute I want/need
If Column "A" includes a name I want those alternate columns to be dragged down to the row, so that the formula's above are dragged down allowing the formula to work
If you get what I mean
Name | Date | Date Renewal | Date | Date Renewal |
James | 01/01/15 | 01/01/16 | 02/01/15 | 02/01/16 |
Michael | 01/01/15 | 01/01/16 | 02/01/15 | 02/01/16 |
Sam | 01/01/15 | 01/01/16 | 02/01/15 | 02/01/16 |
John |
<tbody>
</tbody>
Basically ^^ If John or any other name is written into A. ... the Date Renewal Column drags down, but only to the column where a name is included... is this possible, thanks in advance