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.
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.