I have a budget file (excel) that has a budget amount for each month in a year. What I want to do is to distribute this amount to every day of the month. I guess I need to create some sort of loop do distribute the amount.
First I need to calculate the number of days in each month to know how many times i need to divide my month amount, which really isn't that hard.
But how do I create the loop to distribute the amount? Do I need 2 loops? One for every month and one for each day of the month?