Combining data from multiple workbooks into one

[Median]

Hi all,

I've got ...hundreds.. of csv files which need to be combined into a single workbook. Atm it's a case of copy columns A-D, paste, copy columns A-D, paste & I'm losing the will to live! Surely there's some magic VBA that can speed this up

I've included 3 raw files below (A, AAL, AAP), as well as a sheet showing how the data needs to be arranged ("Combined").

Cheers

Mdn

[Marc L]

Hi,

as your Combined attachment can not contain any code so where must be located the VBA procedure ?!
And you forgot to mention the source text files folder path ! Always the same or can change ?
According to Combined workbook folder : same as the source text files or what ?
As coding can't be guessing …

[CheeseSandwich]

I would use Power Query to import all of the files into one table. GIYBF for Power Query

[Median]

I would use Power Query to import all of the files into one table. GIYBF for Power Query

I did try that but it created a huge single table, which isn't quite what I'm after

[Median]

as your Combined attachment can not contain any code so where must be located the VBA procedure ?!
And you forgot to mention the source text files folder path ! Always the same or can change ?
According to Combined workbook folder : same as the source text files or what ?
As coding can't be guessing …

That's because I manually copied the data, i'm a complete novice when it comes to vba hence I didn't save it as an xlsm. The source folder could be anything (i.e. "desktop/new folder")

[Marc L]

( Removed as I misread )

[Marc L]

According to your hundred of csv files 'Symbol' should be the first column
in order to use some fast way rather than a beginner classic slower VBA way if the layout must stay as it is
so what's your choice ?

Another point : under Windows only ?

[Median]

No "date" is the 1st column.

here's what I'm doing manually

1. Open "A.csv"
2. Copy columns A-D
3. Paste columns A-D into workbook "Combined" columns A-D
4. Open "AAL.csv"
5. Copy columns A-D
6. Paste columns A-D into workbook "Combined" columns F-I
7. Open "AAP.csv"
8. Copy columns A-D
9. Paste columns A-D into workbook "Combined" columns K-N

that help?

I just assumed because it's such a rigid process vba would be a better solution (albeit my vba knowledge is virtually 0!)

[Marc L]

( removed as issue on my side )

[Median]

It's ok Marc tbh I think Cheese's power query solution will work.

Thanks for your time though, appreciated

[jindon]

vba
Place all the csv files and Combined workbook in the same folder.

Please Login or Register  to view this content.

[Median]

That's magic Jindon, cheers mate!