+ Reply to Thread
Results 1 to 2 of 2

Import multiple text files delete rows between lines with File Name

  1. #1
    Registered User
    Join Date
    04-07-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    15

    Import multiple text files delete rows between lines with File Name

    I have around 50 text files with similar design per attached file.
    I need to import the text files with criteria below:-
    1. include file name
    2. let user choose the folder
    3. exclude data from "work in process summary" to "work in process cost totals"
    4. only have one title in the excel files which all text files is combined "Item, Line ....."
    5. If the text files do not have title like "Item, Line, ..." do not import

    Is it possible to have all criteria listed above by running a macro?

    Thanks.
    A.txt

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Import multiple text files delete rows between lines with File Name

    It would help if you could attach a workbook with the data you want to import already in place so we can see your layout. And at least 3 txt files with different data in those. Make them look as real as possible.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 12-12-2012, 04:01 PM
  2. Import Text File Ddata Into Excel Spreadsheet - Multiple Columns & Rows
    By DOgburn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2012, 04:45 PM
  3. import tab delimited text files into excel but skip first 5 lines
    By alexbotea2005 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-28-2011, 05:22 PM
  4. Delete i Rows in Text File Import
    By cswale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2011, 06:50 PM
  5. Import Text File Into A Spreadsheet with over 65,000 lines
    By Ecohouse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2006, 07:45 PM

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