I have an excel spreadsheet that I have tabs seperated out by month in each tab I have Company Name, Inv#, Amount, Account Number, Paid, Check. If the company hasn't paid we label the paid box Reaccrue, and we want all the reaccrue to go over to the next month. So this is where I need help, is it possible to do? I thought of a pivot table but I will also be entering invoices into the next month that will have paid and I will need to total all these together and if it company pays that reaccrue in that month we will want to mark it as paid. Can anybody help me on this????
Bookmarks