I have many .csv files that need to be imported into excel, they are all in the same format with different number name of file.
I'd like to export a select column from a certain file by just enter the file number
For example:
2438.csv contains:
<tbody>
</tbody>
I would want to import csv file 2438, 2439, 2440 of column 3 (Analog 2) of all the step 2
Some results like
<tbody>
</tbody>
Is there a way that I just need to change the number of the file in excel and macros will just import of that file?
Thanks
I'd like to export a select column from a certain file by just enter the file number
For example:
2438.csv contains:
Time | Step | Analog 2 | Analog 3 | Analog 4 |
4:12:51 | 1 | 5 | 7 | 6 |
4:15:51 | 2 | 7 | 8 | 9 |
<tbody>
</tbody>
I would want to import csv file 2438, 2439, 2440 of column 3 (Analog 2) of all the step 2
Some results like
2438 | 2439 | 2440 | ||
Time | Step | Analog 1 | Analog 2 | Analog 3 |
<tbody>
</tbody>
Is there a way that I just need to change the number of the file in excel and macros will just import of that file?
Thanks