I am trying to do a spreadsheetfor my accounts.I need to create a drop down
list of payment type i.e card, cash, cheque.
I need to enter a row of data as eg
Date, supplier, drop down List,materials, legal fees, etc.

if the date and drop down crieria match I want to copy the materials cell to
another sheet.
hope you can help