Help Import Text File and Create Summary

Topic

New Reply

Hi,

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.

Reply | Quote

Replies

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

Reply | Quote