Need vba code with in 10line Split Into Separate Wkbooks Based on Values In a Specific Col

[breadwinner]

Dear sir

How r u I hope you doing well

i have set of data in master sheet from column (A:D)..i want split column value A:A as new workbook into targeted path as indiviual names
if JMS technologies contains 219 row data spilted as newworkbook as JMS technologies like that ...
small obligation code should not 10 lines becoz i want learn vba slowly if code is too long i cant follow of running stes of code that why

i am not able to add attachment workbook ....assume some data from column in sheet a to d split column value is A:A


regards
manilara

[JBeaucaire]

Your request is a common one... split one sheet of data out to separate workbooks using the values in one specific column of that primary sheet. It is NOT only 10 lines of code, so you will have to buckle down and examine one of the many turn-key solutions available on the web. Here's my published solution:
------------------------------
'SHEET1 TO MANY WORKBOOKS
Here's a macro for parsing rows of data from one sheet to many workbooks based on one column, workbooks named for the same values in that column.

Sheet1 to Many Workbooks

My macro names the workbooks for values in the column PLUS today's date, you can take a stab at removing the date part...or leave it in, it's a good technique.