I recorded the macro to import large text file but unable to align it to cells, I need this macro to import text file on regular basis and create a summary of it.
Please some one help with macro to import and create summary from it. The sample text and excel workbook is attached.
Thanks in advance.
Question posted in other forum link: http://windowssecrets.com/foru…t-File-and-Create-Summary