How to Clean an Imported Text file with VBA

**zaska** · 03-16-2013, 02:20 PM

Hello,

I have imported a text file into excel and i want to clean the report by making the following changes.

1. Remove all the rows to the end of the list having dotted lines (-----------)

2. Remove Rows having Product Totals

3. sort the data according to the account number.

4. Merge the headers into a single row

I am herewith attaching the sample file with actual and desired format sheets.

Kindly help me with a vba code .

Regards,

Zaska

**JBeaucaire** · 03-16-2013, 02:51 PM

This should do it:

Please Login or Register  to view this content.

**jaslake** · 03-16-2013, 03:10 PM

Hi zaska

And another

Please Login or Register  to view this content.

**jaslake** · 03-16-2013, 03:40 PM

@ JB

Per a PM I received at 3:21 PM zaska is apparently a student working on an assignment. As an Admin please take whatever steps you feel appropriate.

**JBeaucaire** · 03-16-2013, 08:52 PM

The request for assistance on homework assignments is not a per se rule violation. We just don't typically provide indepth answers to homework, we strive to help OPs understand their issues and rectify them. Now that we know Zaska's question are homework related, we can adjust our responses accordingly.

The solicitation of Excel assistance via Private Messages is a rule violation.

**jaslake** · 03-16-2013, 09:05 PM

@ zaska

Take it for what it's worth...I'm a bit confused...all said and done...you have two solutions to your homework...

For me...I've unsubscribed...