Simply need someone to show me how to consolidate/merge multiple pages/sheets/lines of Excel data to get a net amount. I have attached a spreadsheet as an example. The duplicate information is in bold. I need a NET amount from merging credits and debits. If you thoroughly understand Excel this should be simple.