-2

I have multiple .csv files that need to be in a single .xlsx file, each on it's own tab. I know how to do it manually. is there an automated way do do this? I'm going to need to do this on a monthly basis and there are too many .csv files to do this manually every month

Improve this question
1
  • 2
    You'll need a macro. If they are in the same directory, it's pretty simple. Try to figure it out and then come back if you get stuck.
    – Raystafarian
    Apr 16, 2014 at 13:36

1 Answer 1

Reset to default
2

You can do a macro to automate the import of CSVs. Take a look at Laszlo's answer in this StackOverflow thread, I think you can adapt its macro to your needs.

Improve this answer

Not the answer you're looking for? Browse other questions tagged .