Using VBA to copy across columns until a date is reached

[jaspermowatt]

Hello all,

I am trying to create a dynamic cash flow model where I can type in a start and end date, and run the macro, and the the CFM is auto populated i.e. columns are dragged out until the end date is reached.

I have attached an image of a simplified example.

In my head it seems simple, but I am pretty new to the world of macros and I am struggling to make progress. Any help or guidance would be greatly appreciated. Thank you in advance.

J

 

[Yongle]

Hopefully this method should work for every type of button - if not then let me know which type of button

The name must be acceptable to Excel otherwise it is rejected
-eg no spaces if it's active-x command button

You may need to reassign the macro after re-naming the button

 

[jaspermowatt]

Hopefully this method should work for every type of button - if not then let me know which type of button

The name must be acceptable to Excel otherwise it is rejected
-eg no spaces if it's active-x command button



You may need to reassign the macro after re-naming the button

My developer tab doesn't look like that, is may be because I am on a mac using office 365?

 

[Yongle]

Just a thought
- is it the button caption that you want to change ?

Right click on Forms Control button \ edit text

Active-X
Select design mode \ Right-click on command button \ properties \ amend caption property \ deselect design mode

 

[Yongle]

My developer tab doesn't look like that, is may be because I am on a mac using office 365?

Sorry cannot help
Start a NEW thread and ask the question there and include "mac" in the title
Make it clear wanting amend the caption or rename the object