View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John cheshire lad[_2_] John cheshire lad[_2_] is offline
external usenet poster
 
Posts: 9
Default copy cell contents that meet date and list name criteria



"Otto Moehrbach" wrote:

What constitutes a match? Otto
"John cheshire lad" wrote in
message ...
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