Loop through data that's in blocks of ALMOST always 9 rows, but not EVERY time

[zookeepertx]

Thanks to a couple of the experts on this board, I have a loop that transfers data from sheet 1 (in 1 configuration) to sheet 2 in a totally different configuration. I was under the impression that ALL of the data in the report (on sheet 1) was in blocks of 9 rows, but I've just discovered that occasionally, the blocks are 7 rows. This is all after doing a text-to-columns.

I kind of doubt if this can even be done, but I'm hoping to be able to talk the macro into handling this problem for me. The first cell in column A of each block of data is always a 6 digit number and the second cell in column A of each block is always a 4 digit number.

The first thought I had was to maybe run through sheet 1 before the Loop part of the macro and insert a row or two in any block that is less than 9 rows long, using the 6-digit/4-digit format. But I have NO clue how to achieve this! I'm going to keep thinking about it, but I thought someone here might have a better idea of how to fix the problem.

Here's a small sample of the data in sheet 1 (after the text-to-columns) and sheet 2 (what I want it to look like after the macro) and the Loop part of the macro.
[TABLE="width: 512"]
<COLGROUP><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3626" span=8 width=85><TBODY>[TR]
[TD="class: xl63, width: 85, bgcolor: transparent"]06/30/14[/TD]
[TD="class: xl63, width: 85, bgcolor: transparent"]Page[/TD]
[TD="class: xl63, width: 85, bgcolor: transparent"]1[/TD]
[TD="class: xl63, width: 85, bgcolor: transparent"]of[/TD]
[TD="class: xl63, width: 85, bgcolor: transparent"]9[/TD]
[TD="class: xl64, width: 85, bgcolor: transparent"] [/TD]
[TD="class: xl64, width: 85, bgcolor: transparent"] [/TD]
[TD="class: xl64, width: 85, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]P.[/TD]
[TD="class: xl63, bgcolor: transparent"]O.[/TD]
[TD="class: xl63, bgcolor: transparent"]Box[/TD]
[TD="class: xl63, bgcolor: transparent"]515176[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Los[/TD]
[TD="class: xl63, bgcolor: transparent"]Angeles,[/TD]
[TD="class: xl63, bgcolor: transparent"]CA[/TD]
[TD="class: xl63, bgcolor: transparent"]90051-5176[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Phone[/TD]
[TD="class: xl63, bgcolor: transparent"](562)345-2200[/TD]
[TD="class: xl63, bgcolor: transparent"]Fax[/TD]
[TD="class: xl63, bgcolor: transparent"](562)741-2500[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]B90[/TD]
[TD="class: xl63, bgcolor: transparent"]-[/TD]
[TD="class: xl63, bgcolor: transparent"]Tom[/TD]
[TD="class: xl63, bgcolor: transparent"]Monthly[/TD]
[TD="class: xl63, bgcolor: transparent"]Roster,[/TD]
[TD="class: xl63, bgcolor: transparent"]East[/TD]
[TD="class: xl63, bgcolor: transparent"]Coast[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Performance[/TD]
[TD="class: xl63, bgcolor: transparent"]Team[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Roster[/TD]
[TD="class: xl63, bgcolor: transparent"]of[/TD]
[TD="class: xl63, bgcolor: transparent"]Trailer[/TD]
[TD="class: xl63, bgcolor: transparent"]Manifests[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Manifest[/TD]
[TD="class: xl63, bgcolor: transparent"]#[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Load[/TD]
[TD="class: xl63, bgcolor: transparent"]#[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Created[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Operator[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Consolidator[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Consignee[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Trailer[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]LH[/TD]
[TD="class: xl63, bgcolor: transparent"]Carrier[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Loaded[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Closed[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Departed[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Arrived[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Ctns[/TD]
[TD="class: xl63, bgcolor: transparent"]Pcs[/TD]
[TD="class: xl63, bgcolor: transparent"]Lbs[/TD]
[TD="class: xl63, bgcolor: transparent"]PU$[/TD]
[TD="class: xl63, bgcolor: transparent"]Cons$[/TD]
[TD="class: xl63, bgcolor: transparent"]LH$[/TD]
[TD="class: xl63, bgcolor: transparent"]FSC[/TD]
[TD="class: xl64, bgcolor: transparent"]Total[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Inv[/TD]
[TD="class: xl63, bgcolor: transparent"]#[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Spot[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]1282514[/TD]
[TD="class: xl69, bgcolor: transparent"]Tom[/TD]
[TD="class: xl69, bgcolor: transparent"]Smith[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]8339[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]44047[/TD]
[TD="class: xl63, bgcolor: transparent"]06/26/14[/TD]
[TD="class: xl63, bgcolor: transparent"]11:46[/TD]
[TD="class: xl63, bgcolor: transparent"]PM[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]6/27/2014[/TD]
[TD="class: xl63, bgcolor: transparent"]9:18:00[/TD]
[TD="class: xl63, bgcolor: transparent"]PM[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]6/28/2014[/TD]
[TD="class: xl63, bgcolor: transparent"]4:20:00[/TD]
[TD="class: xl63, bgcolor: transparent"]PM[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]CVEN[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]06/26/14[/TD]
[TD="class: xl63, bgcolor: transparent"]1,045[/TD]
[TD="class: xl63, bgcolor: transparent"]0[/TD]
[TD="class: xl63, bgcolor: transparent"]10905[/TD]
[TD="class: xl63, bgcolor: transparent"]237.59[/TD]
[TD="class: xl63, bgcolor: transparent"]3,271.58[/TD]
[TD="class: xl63, bgcolor: transparent"]865.61[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]patsan[/TD]
[TD="class: xl63, bgcolor: transparent"]Tom[/TD]
[TD="class: xl63, bgcolor: transparent"]Smith[/TD]
[TD="class: xl63, bgcolor: transparent"]Stores-[/TD]
[TD="class: xl63, bgcolor: transparent"]ABC[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"]E0184683[/TD]
[TD="class: xl75, bgcolor: transparent"]500.81[/TD]
[TD="class: xl75, bgcolor: transparent"]127.21[/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]1282546[/TD]
[TD="class: xl69, bgcolor: transparent"]Tom[/TD]
[TD="class: xl69, bgcolor: transparent"]Smith[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]8340[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]3RU594-A[/TD]
[TD="class: xl63, bgcolor: transparent"]06/27/14[/TD]
[TD="class: xl63, bgcolor: transparent"]01:46[/TD]
[TD="class: xl63, bgcolor: transparent"]AM[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]FLY[/TD]
[TD="class: xl63, bgcolor: transparent"]06/27/14[/TD]
[TD="class: xl63, bgcolor: transparent"]01:53[/TD]
[TD="class: xl63, bgcolor: transparent"]AM[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]06/27/14[/TD]
[TD="class: xl63, bgcolor: transparent"]1[/TD]
[TD="class: xl63, bgcolor: transparent"]0[/TD]
[TD="class: xl63, bgcolor: transparent"]500[/TD]
[TD="class: xl63, bgcolor: transparent"]0.00[/TD]
[TD="class: xl63, bgcolor: transparent"]150.00[/TD]
[TD="class: xl63, bgcolor: transparent"]59.94[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]patsan[/TD]
[TD="class: xl63, bgcolor: transparent"]Tom[/TD]
[TD="class: xl63, bgcolor: transparent"]Smith-[/TD]
[TD="class: xl63, bgcolor: transparent"]ABCD[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"]E0184685[/TD]
[TD="class: xl75, bgcolor: transparent"]47.80[/TD]
[TD="class: xl75, bgcolor: transparent"]12.14[/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]1241103[/TD]
[TD="class: xl69, bgcolor: transparent"]Tom[/TD]
[TD="class: xl69, bgcolor: transparent"]Smith[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]7795[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]5800[/TD]
[TD="class: xl63, bgcolor: transparent"]02/19/14[/TD]
[TD="class: xl63, bgcolor: transparent"]06:17[/TD]
[TD="class: xl63, bgcolor: transparent"]PM[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]5/26/2014[/TD]
[TD="class: xl63, bgcolor: transparent"]10:56:00[/TD]
[TD="class: xl63, bgcolor: transparent"]PM[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]5/26/2014[/TD]
[TD="class: xl63, bgcolor: transparent"]11:59:00[/TD]
[TD="class: xl63, bgcolor: transparent"]PM[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]FLY[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]02/19/14[/TD]
[TD="class: xl63, bgcolor: transparent"]575[/TD]
[TD="class: xl63, bgcolor: transparent"]0[/TD]
[TD="class: xl63, bgcolor: transparent"]9121[/TD]
[TD="class: xl63, bgcolor: transparent"]310.20[/TD]
[TD="class: xl63, bgcolor: transparent"]2,736.30[/TD]
[TD="class: xl63, bgcolor: transparent"]837.51[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]cartre[/TD]
[TD="class: xl63, bgcolor: transparent"]Tom[/TD]
[TD="class: xl63, bgcolor: transparent"]Smith-[/TD]
[TD="class: xl63, bgcolor: transparent"]Direct[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"]E0163828[/TD]
[TD="class: xl75, bgcolor: transparent"]415.52[/TD]
[TD="class: xl75, bgcolor: transparent"]111.79[/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]

[TABLE="width: 793"]
<COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 3413" width=80><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 2176" width=51><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 5077" width=119><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2645" width=62><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" width=66><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4693" width=110><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 5376" width=126><COL style="WIDTH: 42pt" width=56><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1365" width=32><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2304" span=3 width=54><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2730" width=64><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2304" width=54><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2986" width=70><TBODY>[TR]
[TD="class: xl72, width: 80, bgcolor: transparent, align: right"]6/30/2014[/TD]
[TD="class: xl66, width: 51, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 119, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 66, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 110, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 126, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 56, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 32, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 70, bgcolor: transparent"]Page 1 of 9[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]PerformanceTeam[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]P.O. Box 515176[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]LosAngeles, CA 90051-5176[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]Phone (562)345-2200 Fax (562)741-2500[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]Roster of Trailer Manifests[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]B90- Tom Monthly Roster, East Coast[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Manifest #[/TD]
[TD="class: xl66, bgcolor: transparent"]Created[/TD]
[TD="class: xl66, bgcolor: transparent"]Consolidator[/TD]
[TD="class: xl66, bgcolor: transparent"]Inv #[/TD]
[TD="class: xl66, bgcolor: transparent"]Trailer[/TD]
[TD="class: xl66, bgcolor: transparent"]Loaded[/TD]
[TD="class: xl66, bgcolor: transparent"]Departed[/TD]
[TD="class: xl65, bgcolor: transparent"]Ctns[/TD]
[TD="class: xl65, bgcolor: transparent"]Pcs[/TD]
[TD="class: xl65, bgcolor: transparent"]Lbs[/TD]
[TD="class: xl65, bgcolor: transparent"]PU$[/TD]
[TD="class: xl65, bgcolor: transparent"]Cons$[/TD]
[TD="class: xl65, bgcolor: transparent"]LH$[/TD]
[TD="class: xl65, bgcolor: transparent"]FSC[/TD]
[TD="class: xl66, bgcolor: transparent"]Total[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Load #[/TD]
[TD="class: xl67, bgcolor: transparent"]Operator[/TD]
[TD="class: xl67, bgcolor: transparent"]Consignee[/TD]
[TD="class: xl67, bgcolor: transparent"]Spot[/TD]
[TD="class: xl67, bgcolor: transparent"]LH Carrier[/TD]
[TD="class: xl67, bgcolor: transparent"]Closed[/TD]
[TD="class: xl67, bgcolor: transparent"]Arrived[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent, align: right"]1282514[/TD]
[TD="class: xl70, bgcolor: transparent"]06/26/14[/TD]
[TD="class: xl70, bgcolor: transparent"]Tom Smith [/TD]
[TD="class: xl70, bgcolor: transparent"]E0184683[/TD]
[TD="class: xl70, bgcolor: transparent"]44047[/TD]
[TD="class: xl70, bgcolor: transparent"]06/26/14 11:46PM[/TD]
[TD="class: xl70, bgcolor: transparent"]6/28/2014 4:20:00PM[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1,045[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]10905[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]500.81[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]237.59[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]3,271.58[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]127.21[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]865.61[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent, align: right"]8339[/TD]
[TD="class: xl71, bgcolor: transparent"]patsan[/TD]
[TD="class: xl71, bgcolor: transparent"]Tom Smith Stores- ABC[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"]CVEN[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6/27/2014 21:18[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent, align: right"]1282546[/TD]
[TD="class: xl70, bgcolor: transparent"]06/27/14[/TD]
[TD="class: xl70, bgcolor: transparent"]Tom Smith [/TD]
[TD="class: xl70, bgcolor: transparent"]E0184685[/TD]
[TD="class: xl70, bgcolor: transparent"]3RU594-A[/TD]
[TD="class: xl70, bgcolor: transparent"]06/27/14 01:46AM[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]500[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]47.8[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]150[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12.14[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]59.94[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent, align: right"]8340[/TD]
[TD="class: xl71, bgcolor: transparent"]patsan[/TD]
[TD="class: xl71, bgcolor: transparent"]Tom Smith- ABCD [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"]FLY[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent, align: right"]1241103[/TD]
[TD="class: xl70, bgcolor: transparent"]02/19/14[/TD]
[TD="class: xl70, bgcolor: transparent"]Tom Smith [/TD]
[TD="class: xl70, bgcolor: transparent"]E0163828[/TD]
[TD="class: xl70, bgcolor: transparent"]5800[/TD]
[TD="class: xl70, bgcolor: transparent"]02/19/14 06:17PM[/TD]
[TD="class: xl70, bgcolor: transparent"]5/26/2014 11:59:00PM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]575[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]9121[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]415.52[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]310.2[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]2,736.30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]111.79[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]837.51[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent, align: right"]7795[/TD]
[TD="class: xl71, bgcolor: transparent"]cartre[/TD]
[TD="class: xl71, bgcolor: transparent"]Tom Smith- Direct [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"]FLY[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]5/26/2014 22:56[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]

Dim nRow As Double
Dim mRow As Double
mRow = 11
nRow = 23
Do While Not IsEmpty(Sheets("Sheet1").Cells(nRow, 1).Value)
        Cells(mRow, 1).Value = Sheets("Sheet1").Cells(nRow, 1)
        Cells(mRow + 1, 1).Value = Sheets("Sheet1").Cells(nRow + 1, 1)
        Cells(mRow, 2).Value = Sheets("Sheet1").Cells(nRow + 6, 1)
        Cells(mRow + 1, 2).Value = Sheets("Sheet1").Cells(nRow + 7, 1)
        Cells(mRow, 3).Value = Sheets("Sheet1").Cells(nRow, 2) & " " & _
            Sheets("Sheet1").Cells(nRow, 3) & " " & Sheets("Sheet1").Cells(nRow, 4)
        Cells(mRow + 1, 3).Value = Sheets("Sheet1").Cells(nRow + 7, 2) & " " & _
            Sheets("Sheet1").Cells(nRow + 7, 3) & " " & Sheets("Sheet1").Cells(nRow + 7, 4) _
            & " " & Sheets("Sheet1").Cells(nRow + 7, 5)
        Cells(mRow, 4).Value = Sheets("Sheet1").Cells(nRow + 8, 1)
        Cells(mRow, 5).Value = Sheets("Sheet1").Cells(nRow + 2, 1)
        Cells(mRow + 1, 5).Value = Sheets("Sheet1").Cells(nRow + 5, 1)
        Cells(mRow, 6).Value = Sheets("Sheet1").Cells(nRow + 2, 2) & " " & _
            Sheets("Sheet1").Cells(nRow + 2, 3) & Sheets("Sheet1").Cells(nRow + 2, 4)
        Cells(mRow + 1, 6).Value = Sheets("Sheet1").Cells(nRow + 3, 1) & " " & _
            Sheets("Sheet1").Cells(nRow + 3, 2) & " " & Sheets("Sheet1").Cells(nRow + 3, 3)
        Cells(mRow, 7).Value = Sheets("Sheet1").Cells(nRow + 4, 1) & " " & _
            Sheets("Sheet1").Cells(nRow + 4, 2) & Sheets("Sheet1").Cells(nRow + 4, 3)
        Cells(mRow, 8).Value = Sheets("Sheet1").Cells(nRow + 6, 2)
        Cells(mRow, 9).Value = Sheets("Sheet1").Cells(nRow + 6, 3)
        Cells(mRow, 10).Value = Sheets("Sheet1").Cells(nRow + 6, 4)
        Cells(mRow, 11).Value = Sheets("Sheet1").Cells(nRow + 8, 2)
        Cells(mRow, 12).Value = Sheets("Sheet1").Cells(nRow + 6, 5)
        Cells(mRow, 13).Value = Sheets("Sheet1").Cells(nRow + 6, 6)
        Cells(mRow, 14).Value = Sheets("Sheet1").Cells(nRow + 8, 3)
        Cells(mRow, 15).Value = Sheets("Sheet1").Cells(nRow + 6, 7)
    nRow = nRow + 9
    mRow = mRow + 2
Loop

Thanks very much!!

Jenny

 

[hiker95]

zookeepertx,

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?

3. Can we have a screenshot of the raw data worksheet, before the text-to-columns?


Even better than a screenshot, can we see your actual raw data workbook/worksheets:

You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[zookeepertx]

Hi hiker95,

Thanks for the reply! I'm using Windows 7, Excel 2010 on a PC. Here's a screenshot of the raw data:

[TABLE="width: 262"]
<COLGROUP><COL style="WIDTH: 262pt; mso-width-source: userset; mso-width-alt: 14890" width=349><TBODY>[TR]
[TD="class: xl65, width: 349, bgcolor: transparent"]06/30/14 Page 1 of 9[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]P. O. Box 515176[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Los Angeles, CA 90051-5176[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Phone (562)345-2200 Fax (562)741-2500[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]B90 - Tom Monthly Roster, East Coast[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Performance Team[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Roster of Trailer Manifests[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Manifest #[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Load #[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Created[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Operator[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Consolidator[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Consignee[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Trailer[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]LH Carrier[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Loaded[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Closed[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Departed[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Arrived[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Ctns Pcs Lbs PU$ Cons$ LH$ FSC Total[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Inv #[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Spot[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]1282514 Tom Smith[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]8339[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]44047 06/26/14 11:46 PM[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]6/27/2014 21:18[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]6/28/2014 16:20[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]CVEN[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]06/26/14 1045 0 10905 237.59 3271.58 865.61[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]patsan Tom Smith- Stores- ABC[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]E0184683 500.81 127.21[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]1282546 Tom Smith[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]8340[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]3RU594-A 06/27/14 01:46 AM[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]FLY 06/27/14 01:53 AM[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]06/27/14 1 0 500 0.00 150.00 59.94[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]patsan Tom Smith- ABCD[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]E0184685 47.80 12.14[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]1241103 Tom Smith[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]7795[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]5800 02/19/14 06:17 PM[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]5/26/2014 22:56[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]5/26/2014 23:59[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]FLY[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]02/19/14 575 0 9121 310.20 2,736.30 837.50[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]cartre Tom Smith- Direct[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]E0163828 415.52 111.79[/TD]
[/TR]
</TBODY>[/TABLE]

I can't upload my workbook from here; my boss would have a cow, LOL!

 

[zookeepertx]

Oh, also - in order to get the existing macro to work right, I'm doing the text-to-columns with everything formatted as text. Otherwise, the dates and times get all screwed up. (Just in case this wasn't going to be difficult enough )

 

[zookeepertx]

I'm sort of thinking maybe a process like this:

mRow = 11 <o></o>
<o></o>
Do While Not IsEmpty(Cells(mRow,1).Value) <o></o>
If A in mRow=6 digits AND A in mRow + 1=4 digits <o></o>
Find next row (rRow) where A=6 digits AND A + 1=4 digits <o></o>
If 8 rows from mRow to rRow, insert 1 row before mRow + 3<o></o>
If 7 rows from mRow to rRow, insert 2 rows before mRow + 3<o></o>
mRow = mRow + 1 <o></o>
Loop


Does that look like an idea?


Jenny

 

[hiker95]

zookeepertx,

Thanks for the screenshots.

I am not able to see a clear cut way to go from column A, raw data text, or, text-to-columns, to the results you are looking for.


Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[zookeepertx]

Okay, thanks for looking anyway!

Jenny

 

[zookeepertx]

Bump.

 

[zookeepertx]

Bump. ANYBODY??