Hello.

I have a large dilemma. I want to use excel for my accounts. I have already got an xls that has 4 sheets inside. Payments, Receipts, Invoices and Summary.

I want to create a new sheet called Business Bank Balance Sheet. I want this to copy multiple RECORDS from Payments and Receipts IF the record uses the business bank.
I know what headings I want to copy and they link directly in each sheet; Date, Reference, Amount and an extra, Payment/Receipt (stating which sheet its from)

I haven't the foggiest. I can send the book to anyone wanting to help. I cant seem to attach it.

Thanks
Tom Clay.