I have a macro enabled workbook. The main worksheet, Year 2019, is made up of rows for the complete year. For example:
Col A
01Jan19
to 31Jan19
01Feb19
to 28Feb19
TO
01Dec19
to 31Dec19
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 as there are 31 rows for January I end up with 31 rows in the other workbook with only the selected columns from the year 2019 worksheet and these rows to be updated automatically when the main worksheet, year 2019, is updated.
There are around 12 columns but the main columns I wish to be also copied to the new workbook are ;
COLA COL D COL F COL H COL I COL M
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.
Bookmarks