Hi Team,
I want to split data into two set and save those two workbook into a thisworkbook.path.
File name - a) Data between 01/01/2020 - 30/05/2020
FileName - b) Data - 01/06/2020 onward...
Criteria to split data are Receipt date between
a) 01/01/2020 - 30/05/2020
b) 01/06/2020 - onwards.
how to achieve this task.
Below is a data
Thanks
mg
I want to split data into two set and save those two workbook into a thisworkbook.path.
File name - a) Data between 01/01/2020 - 30/05/2020
FileName - b) Data - 01/06/2020 onward...
Criteria to split data are Receipt date between
a) 01/01/2020 - 30/05/2020
b) 01/06/2020 - onwards.
how to achieve this task.
Below is a data
Book29 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Receipt Date | xxx | xxx | xxx | ||
2 | 01/01/2020 | xxx | xxx | xxx | ||
3 | 01/02/2020 | xxx | xxx | xxx | ||
4 | 10/03/2020 | xxx | xxx | xxx | ||
5 | 15/04/2020 | xxx | xxx | xxx | ||
6 | 06/07/2020 | xxx | xxx | xxx | ||
7 | 20/08/2020 | xxx | xxx | xxx | ||
8 | 06/09/2020 | xxx | xxx | xxx | ||
9 | 16/07/2020 | xxx | xxx | xxx | ||
10 | 02/07/2020 | xxx | xxx | xxx | ||
11 | 09/09/2020 | xxx | xxx | xxx | ||
Sheet1 |
Thanks
mg