Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Thanked 0 Times in 0 Posts

    Help Import Text File and Create Summary


    Needs macro to import a large text file and align the text to cells and create a summary on next worksheet.
    I find it very difficult in importing it manually, I have attached the sample text file and result excel workbook.
    Some one please help me.

    Thanking in advance.
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    New York, New York, USA
    Thanked 17 Times in 17 Posts
    Dear zmagic:

    Rather than a Macro see the attached. This would have been a bit easier if the text showed the commas in the proper places for the totals. To get around this you will need to use find and replace to eliminate the commas from the text. Once that has been done I have put together various string formulas and created a table in the columns to the right of the data. Next I created a Pivot Table to summarize the information from the text file.

    Hope this helps.

    Tom D
    Attached Files Attached Files

  3. The Following User Says Thank You to duthiet For This Useful Post:

    zmagic (2015-10-22)

Posting Permissions

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