I have a sheet named 'Sales' where invoice data is stored. In cell 'A16' is a list of the customers from which I want to select a customer and then copy all rows where that customer's name is and also where the 'Paid' cell value is set to 'No'. I want to copy it to the 'Statements' sheet from cell 'C14' downward. I've managed to hack some code I've found and this currently will copy all the rows to the 'Statements2' sheet but not based on the customer's name or whether they've paid. I've attached the workbook.
Many thanks
Bookmarks