Split data based on criteria

[Mahesh.sreekakulam]

I have the data in sheet1 reason wise, now i have to split data reason wise in different sheets,kindly help me

[Admin]

Hi Mahesh,

Welcome to ExcelFox !!

If if this link help you. http://www.excelfox.com/forum/f12/sp...-workbooks-33/

[Mahesh.sreekakulam]

error is showing, i am new to macros please help me to solve the issue that i want split data in seet wise.

[Rick Rothstein]

I have the data in sheet1 reason wise, now i have to split data reason wise in different sheets,kindly help me

You have not provided enough information for us to help you. When posting a question on a forum such as this, you must remember that while you can see your data, we cannot; and while you know what you want to do with your data, we only know what you tells us. You will need to post more information so we know what you know. Attaching a copy of an example workbook showing your existing data and another workbook showing us what the data should look like after being processed would go a long way to helping us understand your question. But if you cannot do that (for security reasons perhaps), you should at least show as a few lines of your existing data and then show us what that data should look like on the worksheets you want to split it out to.