david gabra
Member
Hi
Aim to combine the data in the 1st column of each each excel spreadsheet into once consolidated file.
Please help to create me the VB that can do this. I searched and I was unable to do this.
1 .Each excel has a different name.
2. The data for each excel ending in trans is in column A and the number of rows can differ. [ATrans.CSV]
3.The data for each excel endng in White is in column A and column B and the number of rows can differ. AWhite.CSV
4. The tab name is the same as the file name.
5. Can we combine the data so I have one consolidated files ending in Trans. Column A would be the filename or tab name and column B the data.
6. Can we combine the data so I have one consolidated files ending with White. Column A would be the filename or tab name and column B and C the data.
All my files are in a folder call ARC
Eg. files name
AWhite.CSV
ATrans.CSV
BWhite.CSV
BTrans.CSV
due to limit i could not atached the file - ATrans.CSV
but it looks like this.
cell A1 1234 and tab is called ATrans
Exampleoutput
Combined_data_trans.csv
Combined_data_white.csv
Thanks
This would be a really blessing if someone can provide me with the code to run in the combined files.
David.
Aim to combine the data in the 1st column of each each excel spreadsheet into once consolidated file.
Please help to create me the VB that can do this. I searched and I was unable to do this.
1 .Each excel has a different name.
2. The data for each excel ending in trans is in column A and the number of rows can differ. [ATrans.CSV]
3.The data for each excel endng in White is in column A and column B and the number of rows can differ. AWhite.CSV
4. The tab name is the same as the file name.
5. Can we combine the data so I have one consolidated files ending in Trans. Column A would be the filename or tab name and column B the data.
6. Can we combine the data so I have one consolidated files ending with White. Column A would be the filename or tab name and column B and C the data.
All my files are in a folder call ARC
Eg. files name
AWhite.CSV
ATrans.CSV
BWhite.CSV
BTrans.CSV
due to limit i could not atached the file - ATrans.CSV
but it looks like this.
cell A1 1234 and tab is called ATrans
Exampleoutput
Combined_data_trans.csv
Combined_data_white.csv
Thanks
This would be a really blessing if someone can provide me with the code to run in the combined files.
David.