Tracking value changes to a number

I am trying to figure out what formula I would use to track value changes to my Blank Permits.

For example, I have an Export Permit # 05064578 with several items in it with a value of $100,000.  Each month I use that permit number to export several items, each item utilities that permit number which brings that total down in value. Each month I also file for new pemit numbers with new values.

What I am trying to do is track each permit number and the value remaing on that permit. This way I dont go over the amount available on that permit.

My problem is trying to find a formula that tracks each permit number and supplies me with a countdown value.

Not sure I have described it clearly enough though….Any help on a formula would be greatly appreciated.

By: Carolyn

One thought on “Tracking value changes to a number

Leave a Reply

Your email address will not be published. Required fields are marked *