Macro Drag Down Help

Fraserj

Board Regular
Joined
Nov 29, 2015
Messages
54
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

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
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

cooper645

Well-known Member
Joined
Nov 16, 2013
Messages
622
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
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

Board Regular
Joined
Nov 29, 2015
Messages
54
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

Well-known Member
Joined
Nov 16, 2013
Messages
622
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
So C8 would be;

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

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

cooper645

Well-known Member
Joined
Nov 16, 2013
Messages
622
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,519
Messages
5,602,141
Members
414,505
Latest member
quoctrungvu99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top