Excel: Direction for a VBA Logic loop to clean data


I have 159740 lines of data that look simular to this below, item number the next line or several lines locations numbers. I am think possibly some kind of a loop but looking for a starting direction. to put the data into a table file to work with. Any thoughts how to do this?? Thanks Sheet1

A B C D
1 Total For Unit of Measure: 83 83
2 XH3G 3" DUAL TITE GASKETS XH (75PK 342
3 100 100 521 502 4 700 14 1 00004519329 EA 63 63
4 Total For Unit of Measure: 63 63
5 XH4G 4" DUAL TITE GASKETS XH (60PK 343
6 100 100 500 503 2 4 3 1 00004236988 EA 65 65
7 Total For Unit of Measure: 65 65
8 XH5G 5" DUAL TITE GASKETS XH (30PKQ 344
9 100 100 621 602 10 600 13 1 00004598010 EA 43 43
10 Total For Unit of Measure: 43 43
11 XH8G 8" DUAL TITE GASKETS XH (20PK 346
12 100 100 500 503 12 1 4 1 00003603261 EA 20 20
13 100 100 500 503 12 1 4 1 00003603261 EA 10 10
14
Excel Jeanie HTML 4


This question generated 33 answers. To proceed to the answers, click here.

This thread is current as of January 10, 2014.


For more resources for Microsoft Excel