Please delete my old thread (link given below) and need help on the below request.
https://www.excelforum.com/excel-pro...ml#post5195861.
I do have an Macro file with the code where when I paste my data in to Raw data sheet and click on the button it will ask to select the headers on the file and again I need to enter the column header where I need to split the data based on that column and data is getting segregated on the same file.
So I need the data based on below given requirements. Kindly help me on this.
When I click on the macro button, pop up should open to select the report from my local drive(the report will be in .xls or .xlsx or .csv format)
- Once I selected the report it should ask for the column header name to input.
- Once I input the column header name, the data needs to split in to multiple work books based on the unique cell value on the selected column.
- before saving the file the comma "," should be replaced with semicolon";" in any of the cell on the given workbook.
- the splitted work book should be named as "cell value - macro work book name". and file should be save in .csv format
-----for example: macro work book name is "Book1" and I do have the cell value like "ABC", "BCA", "DAB". so when I split the data to multiple workbooks it should name as below.
ABC - Book1
BCA - Book1
DAB - Book1
Please let me know if you need any further details
Bookmarks