General discussion

Locked

Creating multiple sheets in Excel

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?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Creating multiple sheets in Excel

by Duong beo In reply to Creating multiple sheets ...

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)

Collapse -

Creating multiple sheets in Excel

by corby In reply to Creating multiple sheets ...

The question was auto-closed by TechRepublic

Collapse -

Creating multiple sheets in Excel

by Cedric King In reply to Creating multiple sheets ...

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

Collapse -

Creating multiple sheets in Excel

by corby In reply to Creating multiple sheets ...

The question was auto-closed by TechRepublic

Collapse -

Creating multiple sheets in Excel

by corby In reply to Creating multiple sheets ...

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Software Forums