I have single worksheet I want to split into multiple workbooks based upon the value in column D. Column D is filled with dates. Each month I recieved an invoice data file and I need to break the sheet into individual workbooks based upon the date in column D.

For example any line item with a date of 05/05/2014 is one workbook. Any line items with a date of 05/06/2014 is another workbook...etc. The for each workbook created, I also need a special naming convention. If the new workbook contains invoice dates for 05/05/2014, the name of the workbook should be "Invoice Data File - 2014 05 05". If new workbook contains invoice dates for 05/12/2014, new file name if "Invoice Data File - 2014 05 12". And so on.

Thanks in advance for any comments.