I have code given below where 1st code will split the data in the multiple worksheet in the same workbook based on the selected column and I am using the 2nd code to split the multiple worksheets in to multiple work books.
So I need your help to merge the code and the code should work to split the data directly to multiple workbook instead of work sheets. Also I need to assign that code to Command button given in the attached macro work book. Where when I click the command button it should ask for the report(.xls or .xlsx or .csv) and below given codes will take care of remaining workflow to split the data.
1st code
2nd code is given below...
Bookmarks