• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Converts excel sheets into file

N

neeraj2050

Member
Greetings!!

May I know how to convert sheets into excel file

I would appreciate non vba solution

Regards
Neeraj Kumar Agarwal
 
Can you please be more specific about what you are trying to do?

maybe post a sample file?

Most spreadsheet applications will have an Export to Excel function
I would look for that if that is a relevant answer
 
Last edited:
@Hui Sir: Enclosed please find the attachment. Into file, there are three different sheets and I want each sheet to be converted into an Excel file

Regards
Neeraj Kumar Agarwal
 

Attachments

  • Sample File.xlsx
    10.2 KB · Views: 3
Hi ,

If you right-click on the tab name , one of the options displayed is Move or Copy ; clicking on this , and then selecting (new book) in the Move selected sheets to book: dropdown , will move the selected sheet to a new book.

Repeat this for each of the sheets which you wish to move into a new workbook.

Narayan
 
@Narayan Sir : I understand this process. But I am having "n" number of sheets
and getting that process followed one by one would be quite time consuming as want each sheet to be a separate file
 
Hi ,

Even a VBA solution is not going to save too much of time , since for each sheet , you will have to enter the name under which the sheet is to be saved as a workbook.

A few seconds may be saved as far as the right-click and the appropriate selections are concerned , but a major part of the time taken will be in entering the file name.

Narayan
 
You must log in or register to reply here.
Back
Top