Keeping Track of Budget Changes
I am trying to figure out a good way to go about tracking budget changes. The company I work for has multiple programs to track. Each program will usually have the budget adjusted a few times before the program is over. We track these as modifications.
What I would like to do is have a layout that will have three columns with several different elements. (See attached for current layout of Budget Modification sheet). I want to sort by program number, then modification number. When I create a new record I would like to pull, from the total column of the most recent modification and insert into the Budget column of the new record. Is this possible or is there a multi-table/layout solutiton? Any is appreciated as always.