Hey guys, so i have a problem in which i need to populate the columns F G and H Based on values in first B C and D columns. in same way as mentioned in attached file automatically with a formula. So that in first column, there are invoices and the next column the receipt values are taken from receipts column until they sum to the invoice value and last receipt may be split into completing current invoice and then remaining adjusted in the next invoice and corresponding successfully to the Receipt dates as well. As for demo, file is attached. I have 30 years of data for like thousands of rows that are being done manually right now which is going to be very time consuming. If someone can help in this regard, it will be really appreciable and helpful.
Bookmarks