General discussion

  • Creator
    Topic
  • #2083002

    Creating multiple sheets in Excel

    Locked

    by corby ·

    What is the fast and easy way of creating multiple worksheets to contain multiple .csv data files without creating new sheets, and cutting & pasting?

All Comments

  • Author
    Replies
    • #3900527

      Creating multiple sheets in Excel

      by duong beo ·

      In reply to Creating multiple sheets in Excel

      I think it may be neatly done by using Macro. You may want to create a Macro to do the job with 1 data file and then you just add some lines of code to loop the process for the whole thing.

      Good luck,

      Duong beo (Ngo_The_Doung@mail.ryoyu.co.jp)

    • #3882975

      Creating multiple sheets in Excel

      by cedric king ·

      In reply to Creating multiple sheets in Excel

      What do you mean by creating multiple worksheets without creating new sheets? Every csv file will be imported as a seperate sheet.

    • #3882930

      Creating multiple sheets in Excel

      by corby ·

      In reply to Creating multiple sheets in Excel

      This question was auto closed due to inactivity

Viewing 2 reply threads