PDA

View Full Version : VBA Schedule help



ailbhesmith
06-08-2015, 04:55 AM
Hi all,

I was looking for a bit of help.

I need to make a monthly schedule for the rest of year, to plan out controls to be done on a number of funds.

I have about 100 funds, and each one has 5 controls to be done at different intervals. Some are every second month, some are 4 times a year etc...

What I want is a way to divide up the controls so they are equally spread out so one month doesn't have too many. For example, if one control needs to be done on each fund 4 times a year (every three months) I want ot divide this up so i have about an equal number to do every month.

I was also hoping to make it so if I wanted to add a control or fund or remove it, it was a very easy process. Is this possible?

Any tips would be greatly appreciated!

I've attached the information

13629