macro or formula
Hi. I am trying to create a budget in excel. in the first row, i have the
year. in the second row, i have the months of the year. what i would like
to do is the following: I would like to create a general template where I
enter a line item for the budget (e.g., license fee). next to that, i would
like to list the amount, followed by the month and the year that it should
appear in the budget.
e.g., license fee.....$10,000......July......2007
is there a command/macro that I can use that will take the dollar amount and
place it in the correct cell in the budget that corresponds to the month and
year listed? my goal is to not have to manually move dollar amounts around
as timing changes during the budget development process.
Thanks for any suggestions.
|