How to split a sheet of excel workbook into another excel workbook

Copper Contributor

Please explain in detail how to split a sheet of excel workbook into another excel workbook.

 

For Eg: A Work sheet has various countries information. i would want each country information into new excel sheet.

1 Reply

@leninnainar 

Advance information (without guaranteeing that this is the correct one):

Move or copy worksheets or worksheet data

https://support.microsoft.com/en-us/office/move-or-copy-worksheets-or-worksheet-data-47207967-bbb2-4...

 

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here