Hi.
I'm trying to build a cashflow which links into a order book - being contracts that are committed or forecast. The plan is to toggle the inputs/assumptions in this sheet and add new clients (segmented by category) as time goes on.
My goal is to order the client list by business category i.e. piping, structural or tankage in the cash flow and then the respective cashflow of each contract with each client.
See below 2 work sheets which isolates the query to 'Monthly cashflow' cells B4 to B11 and D4-M4 etc.
Bookmarks