Need a Macro to group certain columns and save them as a separate file in specific folder

[acsishere]

Dear Friends,

I have more than 1000 rows and 100 columns of data.

I need a MACRO to separate Cols. A, B along with unique values in Row #2 then that file should be saved in a separate folder as per the value in Col.B.

I attached a sample file in which I furnished all details.

I request your kind help.

[acsishere]

Request kind help... please...

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[acsishere]

Dear Sir,

Thanks for your magical code. It solves the purpose. A little error I found, when executed.

I request your magic hand to clear the problem.

Please Sir...

[JOHN H. DAVIS]

I received your PM. The reason the macro is not working now is that you revised your requirements. You added another Jun-13 for "AAA". That would cause the error you are receiving. The macro steps by 2 and creates sheets based on pairs or one. How many elements for each sheet can there be?

[acsishere]

Dear Sir,

Thanks for your kindness & reply.

Actually, the data is only the sample to show the requirements.

The minimum & maximum number of elements will be: from 1 to 12. (i.e. number of each elements may vary from 1 to 12).

Request your kind help.

[JOHN H. DAVIS]

Try this:

Please Login or Register  to view this content.

[acsishere]

Sir, Excellent. It's working nicely. No words to express my Gratitude.

Thanks. Thanks a lot. It solved my huge task.

Regards.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback and reps.