View Single Post
  #3   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

I Have rows of input data as follows under
Date Pay type, Tools, fuel, Hotel
etc
2/5/08 card ( from Drop down) 10.52
6/5/08 cash 12.55

I need to extract data that meets the criteria of where the monet was spent
for , i.e. fuel that falls in the month.
I have created a drop down list to select type of payment and then I would
enter the amount under the particular heading.
Can I use sumproduct for the date but can it be used also with an array as
in the drop down list.
Any help would be much appreciated.



"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