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
|