Forum Discussion

leninnainar's avatar
leninnainar
Copper Contributor
Nov 30, 2020

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

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.

Macros and VBA

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Nov 30, 2020

    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-4e95-9b5c-3c174aa69328?ui=en-us&rs=en-us&ad=us

     

    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

     

     

     

     

Resources