Forum

Macro split data fi...
 
Notifications
Clear all

Macro split data file into unique worksheet and rename

5 Posts
2 Users
0 Reactions
131 Views
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

How to split data file into each individual worksheet baesd on each code change ?and rename the worksheet based each code

Pls refer attached sample data

 
Posted : 13/03/2019 2:06 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi David

You can refer here for the VBA codes:

https://www.extendoffice.com/documents/excel/1174-excel-split-data-into-multiple-worksheets-based-on-column.html

 
Posted : 13/03/2019 10:08 am
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

Thanks Sunny will have a go on that..

 
Posted : 13/03/2019 8:11 pm
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

It works perfectly, thank Sunny! With Sunny Excel works always become sunny..

 
Posted : 13/03/2019 8:44 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Embarassed

Thanks for your compliment. Glad to know it is working well for you.

Cheers

Sunny

 
Posted : 14/03/2019 4:08 am
Share: