I have this spreadsheet where I have international and regional suppliers separated by color and I have any payments having to do with invoice down payment or balance payments in another color as well as import duty taxes in a different color.
This is a cash flow projection per month and I need to be able to group all of the monthly down and balance payments into one cell of each month and all the import duty taxes into another cell of the same month all while keeping the individual shipment per supplier data separated by row at the bottom of the cash flow.
What would be the best way to go about doing this?
Bookmarks