Macro: Loop Through Date Field, Copy And Paste Records Into Relevant Worksheet

[jsmith2018]

Hello,

I am looking to create a macro that selects records based on their date field (this data is stored in a worksheet called "AllData") and copy and pastes these records into the correct month's worksheet in the same Excel file (i.e. "January 2018", "February 2018", etc).

I've created a mock Excel file and attached a screenshot to better explain what I am trying to accomplish. The macro would loop through the data in the "AllData" worksheet, select all records that were taken in January, paste these records into the "January 2018" worksheet, then repeat the process for February, March, etc.

Any help is greatly appreciated. Thank you for your time.

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-pr...ata-to-separate-worksheets-based-on-date.html

Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html