hi, i would like to extract some data based on the date (Between dates) using userform (date start and date end)
example data below
SHEET1
<tbody>
</tbody>
using my userform :
date start Jan 1, 2018
date end Jan 31, 2018
RESULTS SHOULD BE (NOTE: The column arrangement will be different from the original data)
SHEET2
<tbody>
</tbody>
thanks in advance for the help
example data below
SHEET1
A | B | C | D | E | |
DATE | REF | CODE | AMT | NAME | |
1 | JAN 2, 2018 | AAA | 111 | 25.25 | STEVE |
2 | JAN 7, 2018 | ABC | 123 | 654.00 | JOHN |
3 | FEB 6, 2018 | DFS | 364 | 215.40 | MICHAEL |
4 | JAN 10, 2018 | GSS | 571 | 10.50 | KURT |
5 | MAR 5, 2018 | HDS | 641 | 557.10 | MIKE |
6 | FEB 15, 2018 | DSE | 558 | 211.20 | JOAN |
7 | FEB 8, 2018 | JER | 011 | 321.00 | HULK |
8 | JAN 26, 2018 | KYT | 317 | 64.00 | SPARK |
<tbody>
</tbody>
using my userform :
date start Jan 1, 2018
date end Jan 31, 2018
RESULTS SHOULD BE (NOTE: The column arrangement will be different from the original data)
SHEET2
A | B | C | |
DATE | NAME | AMT | |
1 | JAN 2, 2018 | STEVE | 25.25 |
2 | JAN 7, 2018 | JOHN | 654.00 |
4 | JAN 10, 2018 | KURT | 10.50 |
8 | JAN 26, 2018 | SPARK | 64.00 |
<tbody>
</tbody>
thanks in advance for the help