Split a excel into multiple worksheet with only few required columns

[Zila]

Can anyone suggest me code to split a excel into multiple worksheet based on one column and all the worksheet should be created with only selected column in it. Kindly help?

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jolivanes]

Do you mean to create a new Worksheet for every Column in a Sheet?
If so, what would you name these added Sheets? Maybe the Header value?
The best is to do what Pepe asked.