data extraction from multiple files

[AnushPatel]

Hello,

Scenario:

Master.xlsx (sheet 1) in folder 'main' needs to be populated in columns A:F with data from the data in sheet 1 of each of A1.csv, B1.csv, C1.csv (all located in 'source' folder).

A1.csv (sheet 1) has data from A1:F60
B1.csv (sheet 1) has data from A1:F142
C1.csv (sheet 1) has data from A1:F93

All 3 csv files data need to be copied across to Master.xlsx (sheet 1) in columns A:F REPLACING any data already in the sheet with each set of data under eachother (doesn't matter what order).

So eventually Master.xlsx (sheet 1) will be populated from A1:F295 (60+142+93) by the end of the process. The process is run each week and the columns of the source date will remain fixed (A:F) but the number of rows will vary (so cannot be fixed).

I'm aiming to automate this process (can be a manual trigger though).

Any help appreciated. If I've missed anything please let me know.

Thanks

Anush

[Glenn Kennedy]

Can you use third party software? If so, INDIRECT.EXT will do what you want.


http://www.ashishmathur.com/tag/indirect-ext/

[anand_babu123]

Hi,

Take a look on these links.

http://chandoo.org/wp/2010/02/19/exc...solidate-data/

http://chandoo.org/wp/2012/04/09/con...cel-files-vba/

Thanks,
Anand