Splitting names in to sheets in alphabetical order

Hello catchnanan,

I have added a button to the "Names" sheet. It will run the macro below which creates a new workbook for each name. The serial number appears in "A1" and row 2 will display the name and information associated with it.

Please Login or Register  to view this content.

Change to

Please Login or Register  to view this content.

Hai alf ,jindon ,leith ross ,thank u very much for all your assistance...
I am very happy that one major problem of bringing other columns in to the sheets is solved..
As i told earlier ,two drawbacks (still exists) of these macro are
1) after shooting of names to other sheets,the names are displayed in all the sheets without serial numbers 1,2,3,ets
2) In the sheet "names" the macro does not have the control over which column it is considering to break the names,
by default ,it takes the first used column and it splits according to what is available in the first used column (for example if serial no is present in the first column,it splits these serial numbers and generates sheets like 1,2,3,4 etc)which is wrong ...It will be very fine it should always take from second column and also mainly cell B2 because it should leave space for title ,otherwise title name also go to some sheets...
So only if the first column is entirely empty ,it takes the names in the second column so i am unable to add serial numbers or any other things in the first column...

Hai alf ,jindon ,leith ross ,thank u very much for all your assistance...
I am very happy that one major problem of bringing other columns in to the sheets is solved..
As i told earlier ,two drawbacks (still exists) of these macro are
1) after shooting of names to other sheets,the names are displayed in all the sheets without serial numbers 1,2,3,ets
2) In the sheet "names" the macro does not have the control over which column it is considering to break the names,
by default ,it takes the first used column and it splits according to what is available in the first used column (for example if serial no is present in the first column,it splits these serial numbers and generates sheets like 1,2,3,4 etc)which is wrong ...It will be very fine it should always take from second column and also mainly cell B2 because it should leave space for title ,otherwise title name also go to some sheets...

Hai dear thank u very much ...It is very nice ..and 100 % perfect and I am really happy about it.I really thanks all the guys who helped me.. Last but least can this macro be further taken to the level where it ask us the column no when we run the macro,and if we give column no 4 it should break and create sheets based on the names in column 4 and so on

thank u soooo much .It is amazing

I am sorry to disturb u friend ,is there any way to create message box which asks us "Do u wnt to clr the old data?" depending upon yes or no ,it should either clear the existing data in all the sheets and replaces with the new one when the macro is run otherwise when the macro is run the date should be added to the existing data in the sheets.