Dear all,

I have never used Macro's before.

I have a simple invoice spreadsheet that list information such as date
received; supplier; amount etc.

One of the fields has a "Y" "N" filter to show if the invoice has been paid
or not.

I want to write a Macro that will extract all the lines of invoices that
have not been paid to a new spreadsheet (the invoice spreadsheet has roughly
5 sheets of invoices).

Any help will be much appriciated.

Thanks

Richard