• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SPLIT data

ssj011

New Member
HI ,

Need a macro to split data basis value in column B. Attached herewith sample data for your reference. Data size is huge sheet can have 10 lacs data as well.

Thanks..

Regards
Sachin
 

Attachments

  • Test Macro.xlsx
    34.8 KB · Views: 10
  • Test Macro.xlsx
    34.8 KB · Views: 4
Hello Sachin,

Your request is not clear. You will have to describe requirement clearly to get help from the forum users.

What do you mean by splitting data on the basis of column value in B? Do you intend to split it into different worksheets or do you want to split some columns?

Explain your needs clearly or better still provide sample output.
 
I want a macro to split data basis region by creating region wise sheets.

Apologies for not giving the clear requirements.

Thanks for your assistance.

Regards
Sachin
 
The macro blah in the attached should get you started.
 

Attachments

  • Chandoo41567Test Macro.xlsm
    43.7 KB · Views: 8
Back
Top