Look at Sheet1 the raw data , Look at Sheet 2 , manually done work
Macro required to do sheet 2
- It should first plug totals , spread the totals over invoices and do the rest
Look at Sheet1 the raw data , Look at Sheet 2 , manually done work
Macro required to do sheet 2
- It should first plug totals , spread the totals over invoices and do the rest
in Sheet1
in H2
=IF(SUM($F$2:F2)<=$G$21,F2,MAX($G$21-SUM($F1:F$2),0))
in I2
=F2-H2
in J2
=IF(I2>0,"PENDING","")
Last edited by JohnTopley; 08-05-2022 at 09:38 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
This is beautiful John , formula achieved and no need of macro
Closing the Thread , if you only add me how many days is the pending at column K , after writing 30-Mar-2021 on A21
Thank you very much again JOHN , u have put me into shock mode , i thought only macro would have done that
in K2
=IF($J2="PENDING",$A$21-$A2,"")
Got u John T , thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks