+ Reply to Thread
Results 1 to 1 of 1

Import Multiple CSV's into single worksheet

  1. #1
    Registered User
    Join Date
    01-31-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Import Multiple CSV's into single worksheet

    Hi guys, first time poster... looking for some help/advice. I know this question has been answered in part for some other requirements but cant seem to apply those resolutions to my problem...

    I am trying to create a macro that will follow these basic steps:

    *Clear all data in my worksheet "Data"
    *Prompt and allow the user to select multiple csv files (from possibly different directories)
    *Import specific data from the csv files: B29 and C29 down to the last row containing data
    - example attached
    *Import this data to my master workbook (worksheet "Data") but obviously do not overwrite and append each files data to the bottom of each imported file
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1