I have a macro enabled workbook. The main worksheet, Year 2019, is made up of rows for the complete year.
01Jan19
to 31Jan19
.
.
01Dec19
to 31Dec19
Each day of month e.g. 01Jan19, may have one or more rows. The format of this date field is nnmmmnn
i wish extract all rows for a given month to another workbook eg jan or feb or dec. so if there are 31 rows for January I end up with 31 rows in the other workbook and only the selected columns from the year 2019 worksheet
and these rows to be updated automatically when the main worksheet, year 2019, is updated.
The main column headings are ;
start date - subject - who booked - start time - end time - description
These key columns are either text or date or time formatted.
can anyone assist in providing a formula to achieve this.
thank you for your consideration.
01Jan19
to 31Jan19
.
.
01Dec19
to 31Dec19
Each day of month e.g. 01Jan19, may have one or more rows. The format of this date field is nnmmmnn
i wish extract all rows for a given month to another workbook eg jan or feb or dec. so if there are 31 rows for January I end up with 31 rows in the other workbook and only the selected columns from the year 2019 worksheet
and these rows to be updated automatically when the main worksheet, year 2019, is updated.
The main column headings are ;
start date - subject - who booked - start time - end time - description
These key columns are either text or date or time formatted.
can anyone assist in providing a formula to achieve this.
thank you for your consideration.