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,191
    Thanks
    48
    Thanked 984 Times in 914 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
    2,826
    Thanks
    136
    Thanked 482 Times in 459 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,637
    Thanks
    115
    Thanked 650 Times in 592 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
  •