Hello....
I have this table below and I need to filter it (column K) based on column M using below code, but it didn't work.
Can someone please help me? I don't know which part of the code is wrong.
Thank you in advance.
I have this table below and I need to filter it (column K) based on column M using below code, but it didn't work.
Can someone please help me? I don't know which part of the code is wrong.
Thank you in advance.
VBA Code:
ActiveSheet.Range("$A$1:$Y$501").AutoFilter Field:=11, Criteria1:=Cells(i, 13)| Book1 | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
| 1 | Sales Date | Inv. Date | Cust. Code | Order No. | Item | Ctn | Delivery code | Customer Name | Phone no | PIC code | Actual delivery | Actual delivery | FileName | |||
| 2 | 2024/8/6 | 2024/8/6 | ARA25000 | 00640200 | BM92 | 2 | ARA05001 | MIT | 03-1234-5678 | 108 | 2024/8/6 | 2024/8/6 | 20240806 | |||
| 3 | 2024/8/6 | 2024/8/6 | ARA25000 | 00000004 | BM92 | 3 | ARA05001 | MIT | 03-1234-5678 | 108 | 2024/8/6 | 2024/8/7 | 20240807 | |||
| 4 | 2024/8/6 | 2024/8/6 | ARA25000 | 00000004 | BM92 | 1 | ARA05001 | MIT | 03-1234-5678 | 108 | 2024/8/6 | |||||
| 5 | 2024/8/6 | 2024/8/6 | ARA25000 | 00000004 | BM92 | 1 | ARA05001 | MIT | 03-1234-5678 | 108 | 2024/8/6 | |||||
| 6 | 2024/8/7 | 2024/8/7 | ARA25000 | 00000011 | BM92 | 1 | ARA05001 | MIT | 03-1234-5678 | 108 | 2024/8/7 | |||||
| 7 | 2024/8/7 | 2024/8/7 | ARA25000 | 00000011 | BM92 | 1 | ARA05001 | MIT | 03-1234-5678 | 108 | 2024/8/7 | |||||
| 8 | 2024/8/7 | 2024/8/7 | ARA25000 | 00000011 | BM92 | 1 | ARA05001 | MIT | 03-1234-5678 | 108 | 2024/8/7 | |||||
Sheet1 | ||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| N2:N3 | N2 | =TEXT(M2,"yyyymmdd") |
