Hi
I have a ledger with multiple dates, invoices, amounts and payments on sheet 1 which is my main sheet.
On worksheets 2-6 I have the suppliers ledgers.
Now I need to match the invoice number and amount which can be anywhere in sheet 2-6 including payments.
Please assist
I have a ledger with multiple dates, invoices, amounts and payments on sheet 1 which is my main sheet.
On worksheets 2-6 I have the suppliers ledgers.
Now I need to match the invoice number and amount which can be anywhere in sheet 2-6 including payments.
Please assist
