L
Lemi
I have a database in the following pattern:
DATE REMARK DEBIT CREDIT BANK CUST
01.01.09 xyxyxyx A X
-----------------------------------------------------------
10.04.09 jsstmjk B Y
----------------------------------------------------------
10.07.09 sklsjhs A Y
I want to extract the transactions of a certain customer (say X) between two
dates and I want to do it in the code.
My criteria range is like the following:
Columns
5 6 7
Rows 1 DATE DATE CUST
2 >=01.03.09 <=31.05.09 X
Excel do not extract any records although there are several ones matching
those criteria. Why?
If I remove the dates then I get a correct extract for customer X but I
cannot filter it between the given dates.
Is there anything wrong with the punctuation in the cells for dates?
P.S. I don't want to use the advance filter from the menu. It must be dealt
with in the code.
Regards,
Lemi
DATE REMARK DEBIT CREDIT BANK CUST
01.01.09 xyxyxyx A X
-----------------------------------------------------------
10.04.09 jsstmjk B Y
----------------------------------------------------------
10.07.09 sklsjhs A Y
I want to extract the transactions of a certain customer (say X) between two
dates and I want to do it in the code.
My criteria range is like the following:
Columns
5 6 7
Rows 1 DATE DATE CUST
2 >=01.03.09 <=31.05.09 X
Excel do not extract any records although there are several ones matching
those criteria. Why?
If I remove the dates then I get a correct extract for customer X but I
cannot filter it between the given dates.
Is there anything wrong with the punctuation in the cells for dates?
P.S. I don't want to use the advance filter from the menu. It must be dealt
with in the code.
Regards,
Lemi