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
1 Answer
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.