AnsweredAssumed Answered

Keeping Track of Budget Changes

Question asked by RobbyHagen on Sep 15, 2011
Latest reply on Sep 16, 2011 by philmodjunk


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.