experchange > excel.* > excel.main

Sultana (03-05-20, 03:38 PM)
Hello,
I have temperature data with respect to time of different sensors in separate csv files. Time is same but temperature is varying for all the files. I was trying to create an option where I can give command in macros to copy only the temperature values from all the csv files in one excel sheet in different columns.Can anyone please help me with this.
GS (03-05-20, 09:13 PM)
> Hello,
> I have temperature data with respect to time of different sensors in separate
> csv files. Time is same but temperature is varying for all the files. I was
> trying to create an option where I can give command in macros to copy only
> the temperature values from all the csv files in one excel sheet in different
> columns.Can anyone please help me with this.


Are the CSV file columns all the same location?
Do the CSV files contain headers in the first line?
Can you provide sample CSV files and workbook for download?
Similar Threads