Dear All,
I need help with a VBA code for the following , please
- Allocate an amount over time, and split the amount into monthly column, based on a period start and end dates & number of days in each month
- e.g Start Date: 01/01/2019 – End Date 31/03/2019, & the spreadsheet has monthly columns for entering values. Using the start and end dates, I would like to be able to do these:
1. If I run the code in Sep 18, I would like the figures to go into columns JAN 19, FEB 19, & MAR 19. I do not want anything in SEP 18 – DEC 18 columns
2. If I run the code in Feb 19, I do not want any figures to go into Jan 19. Jan 19 & Feb19 figure will go into Feb 19 column, Mar 19 figure into Mar 19.
Thank you in advance for your help.
I need help with a VBA code for the following , please
- Allocate an amount over time, and split the amount into monthly column, based on a period start and end dates & number of days in each month
- e.g Start Date: 01/01/2019 – End Date 31/03/2019, & the spreadsheet has monthly columns for entering values. Using the start and end dates, I would like to be able to do these:
1. If I run the code in Sep 18, I would like the figures to go into columns JAN 19, FEB 19, & MAR 19. I do not want anything in SEP 18 – DEC 18 columns
2. If I run the code in Feb 19, I do not want any figures to go into Jan 19. Jan 19 & Feb19 figure will go into Feb 19 column, Mar 19 figure into Mar 19.
Thank you in advance for your help.
