1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Import specific column from different csv file

    From Sultana@21:1/5 to All on Thu Mar 5 05:38:25 2020
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From GS@21:1/5 to All on Thu Mar 5 14:13:46 2020
    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?

    --
    Garry

    Free usenet access at http://www.eternal-september.org
    Classic VB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)