How to allocate points spent to previous points earned time stamp ledger using VBA and Excel

[Nomikos]

Hi, can anyone help me with a formula or VBA code to create a cumulative running total of loyalty points earned and Date stamped, which are valid for 1 year? Then when points are spent at a future date, the spent points are then allocated to the first Date stamped points in the table until the points have been distributed down the line. When additional points are earned and spent they will continue from the last allocation row. I am guessing this is likely to need multiple tables and probably a complex formula. Help is much appreciated. Thank you in advance.