Split the excel based on headings

[gopalpithani]

i have a heading and some data.next heading and some data. i want split this in to different workbooks containing heading and its data using VBA. Can any one help me in this regard. Thanks in advance.i am attaching main file and sample output file to have an idea.

[Paul_Hossler]

Since you already have a thread going with the same issue and what appear to be the same test files:

http://www.vbaexpress.com/forum/showthread.php?63228-Split-the-excel-based-on-headings-list

It'd be better to not start a new one

[georgiboy]

On a side note:

I help on this forum free if charge, I may not be the ultimate in VBA but I try my hardest to help.

It is not a good practice to start sending private messages to push people to help. Maybe spare a thought for international time differences.

Starting a new thread the way you have is really not helpful and will potentially waste people's time and effort.