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
Bookmarks