I have this VB code that looks up budget info in a different program. The
output is an excel table sorted by period and then account number. The way it
works is it looks up the budget for an account for period one then puts this
in the table. Then checks the value for period 2 etc. When it is done with
one account it loops through the second account and so forth. At the end the
vb sorts the table by period and account number so i have to budget for all
the account for period 1 and then period 2 etc.
What I want to do is have the code add up the budget per period and only
give me a table in which i see the budget per account for the whole year
instead of per month.
Is there a way to store the values for each poriod in the loop and then only
put the total in the table? Can anyone help with with an example?