Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with CSV. Copy values from 100 CSVs into an excel

    I'm a newbie to this forum and have a question on Copy from CSV to Excel

    I have 100 CSV in a folder with values in 1st two columns.

    I would need to copy the values from CSV into Excel. For example

    From the 1st CSV, copy the values from Column1 and column 2 and paste into column 1 and column 2 of the destination excel and sum the values at the last row of the column
    From the 2nd CSV, copy the values from Column1 and column 2 and paste into column 3 and column 4 of the destination excel and sum the values at the last row of the column
    From the 3rd CSV, copy the values from Column1 and column 2 and paste into column 5 and column 6 of the destination excel and sum the values at the last row of the column

    and so on...

    Any help would be highly appreciated
    Thanks in advance

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,889
    Thanks
    60
    Thanked 1,098 Times in 1,021 Posts
    If you want to do it manually (you probably don't) you would open each CSV and then copy / paste into your master spreadsheet.
    To do it easily you need a macro. I'm sure someone will scratch something up for you to try.

    cheers, Paul

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,348
    Thanks
    162
    Thanked 623 Times in 591 Posts
    Hi naga

    Welcome to the Lounge!

    ..I have attached a sample file that should do as you ask.

    zeddy
    Attached Files Attached Files

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,884
    Thanks
    147
    Thanked 734 Times in 666 Posts
    Very slick zeddy!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •