Macro Drag Down Help

[Fraserj]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Date
[/TD]
[TD]Date Renewal
[/TD]
[TD]Date
[/TD]
[TD]Date Renewal
[/TD]
[/TR]
[TR]
[TD]James
[/TD]
[TD]01/01/15
[/TD]
[TD]01/01/16
[/TD]
[TD]02/01/15
[/TD]
[TD]02/01/16
[/TD]
[/TR]
[TR]
[TD]Michael
[/TD]
[TD]01/01/15
[/TD]
[TD]01/01/16
[/TD]
[TD]02/01/15
[/TD]
[TD]02/01/16
[/TD]
[/TR]
[TR]
[TD]Sam
[/TD]
[TD]01/01/15
[/TD]
[TD]01/01/16
[/TD]
[TD]02/01/15
[/TD]
[TD]02/01/16
[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

 

[cooper645]

Could you change the formulas to include an extra bit

=IF($A1="","","your formula here")

and then drag down the entire column to say row 100.

it says if A1 is equal to "" (blank), then make this cell value "" (blank), otherwise do this formula

maybe this is a possibility, then when you add a name the formula is already there, it just ""appears""

 

[Fraserj]

Could you change the formulas to include an extra bit

=IF($A1="","","your formula here")

and then drag down the entire column to say row 100.

it says if A1 is equal to "" (blank), then make this cell value "" (blank), otherwise do this formula

maybe this is a possibility, then when you add a name the formula is already there, it just ""appears""

I'm trying that, it doesn't seem to work
The formula I've used isn't hard, just in column C8 .... =B8+365
Any ideas?

 

[cooper645]

So C8 would be;

=IF($A8="","",B8+365)

should return urn the formula result in cell c8, as long as a8 is not blank

 

[Fraserj]

Thank you, works perfectly, and thank you for replying so quickly

 

[cooper645]

No problem. Can prefill cells and then they appear when needed.

Any my more problems post back. I'll check thread in the morning.

Good luck