Extract of data based on specific criteria

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.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

Pete

Thank you for responding so quickly. I attach an example of the data - obviously sanitised. This is in worksheet Year 2019.

I have also created example worksheets - Jan / Mar / Dec with the required column headings and where the data should be extracted from on sheet year 2019.

Each day in the month may have +/- 6 rows

Would it also be possible to make the formula not year dependant to support year rollover?

Thanks again.

Glen, thank you for the formula. The formula extracts the contents for text data. However, for cells that contain a date and / or time data I just get a number. I have formatted the cells with a date format and time format I require but the formula appears to be overriding the cell contents that have been formatted with either ddmmmyy or hh:mm.

Also, when the formula no longer finds the specified month I get a #num! entry?

Thank you for your assistance and time.

Glen, I have copied the formulas you very kindly provided to the 'Mar' worksheet. I have changed 'jan' for 'mar'. See attached.
In column A in your 'jan' example once the formula cannot find the month of 'jan' it returns a 'blank' / empty cell which is great. However, in the 'Mar' worksheet it returns a #num! when it cannot find 'mar'. Obviously the other formulas have an if statement based on the results in column A.

I must be doing something wrong as your solutions works ok for Jan but not another month. Can you please assist. Thank you.

Glenn, thank you so much. This appears to be working just great. I will do some more testing.

Glenn may I ask another question. If I wanted to hold the extracted data from worksheet Year 2019 in another workbook for any given month how would the formula need to change. Thanks again.

This has been resolved. Thank you very much for your time and effort.