Hi - apologies, I am a bit of newbie to this. I have a spreadsheet that has many invoice items, each row has an account number, many of which are duplicates as they are separate invoices for individual accounts. What I want to do is create output that shows invoice rows if the amount for a particular account number exceeds a certain amount. My spreadsheet, which has many columns, has the account number in one column and the amount they owe for each invoice in another column. If the total exceeds a certain amount for a particular account, I would like each individual row for that account to be displayed in a separate worksheet. Hope this makes sense, would anybody be able to help?
