Need to copy blocks of data from sheet 1 to sheet 2, but not in the same order

zookeepertx

zookeepertx

Well-known Member
Joined
May 27, 2011
Messages
586
Office Version
  1. 365
Platform
  1. Windows
Hello!

I have a PDF file that I'm trying to work with in Excel. We only have access to Adobe Reader, not Acrobat, so that's a problem. Anyway, I figured out how to get the data all into Column A of a spreadsheet, then do a text-to-columns, using space as a delimiter. I can't see any other way to break up the data; there are no commas, semi-colons or anything. Naturally, this plays the devil with the formatting! So, the only thing I can think to do, is to have a macro that will move the data to a second sheet, in the correct order, so that I can work with it further.

Here's what it looks like before doing text-to-columns:
[TABLE="width: 177"]
<TBODY>[TR]
[TD="width: 236, bgcolor: transparent"]06/30/14 Page 1 of 9
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]P. O. Box 123456
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Los Angeles, CA 90051-5176
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Phone (562)345-2200 Fax (562)741-2500
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]B90 - Smith Monthly Roster, East Coast
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Trailering Team
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Roster of Trailer Manifests
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Manifest #
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Load #
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Created
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Operator
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Consolidator
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Consignee
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Trailer
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]LH Carrier
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Loaded
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Closed
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Departed
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Arrived
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Ctns Pcs Lbs PU$ Cons$ LH$ FSC Total
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Inv #
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Spot
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1241103 John Smith
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7795
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]5800 02/19/14 06:17 PM
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]5/26/2014 22:56
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]5/26/2014 23:59
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]FLY
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]02/19/14 575 0 9121 310.20 2,736.30 837.51
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]cartre John Smith- Direct
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]E0163828 415.52 111.79
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]34561546 John Smith
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8854
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]7200 02/19/14 06:17 PM
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]5/26/2014 22:20
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]5/26/2014 23:30
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]GROUND
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]02/19/14 363 0 5142 253.1 3,456.23 951.26
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]cartre John Smith- Direct
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]E0163242 215.11 213.56
[/TD]
[/TR]
</TBODY>[/TABLE]

Here's what it looks like AFTER the text-to-columns. (I've color coded it to help me see whe:
[TABLE="width: 497"]
<TBODY>[TR]
[TD="class: xl65, width: 83, bgcolor: transparent, align: right"]6/30/2014
[/TD]
[TD="class: xl66, width: 80, bgcolor: transparent"]Page
[/TD]
[TD="class: xl66, width: 95, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl66, width: 80, bgcolor: transparent"]of
[/TD]
[TD="class: xl66, width: 43, bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl66, width: 57, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 194, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 31, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]P.
[/TD]
[TD="class: xl66, bgcolor: transparent"]O.
[/TD]
[TD="class: xl66, bgcolor: transparent"]Box
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]123456
[/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"]Los
[/TD]
[TD="class: xl66, bgcolor: transparent"]Angeles,
[/TD]
[TD="class: xl66, bgcolor: transparent"]CA
[/TD]
[TD="class: xl66, bgcolor: transparent"]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]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Phone
[/TD]
[TD="class: xl66, bgcolor: transparent"](XXX)XXX-XXXX
[/TD]
[TD="class: xl66, bgcolor: transparent"]Fax
[/TD]
[TD="class: xl66, bgcolor: transparent"](XXX)XXX-XXXX
[/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"]B90
[/TD]
[TD="class: xl66, bgcolor: transparent"]-
[/TD]
[TD="class: xl66, bgcolor: transparent"]Smith
[/TD]
[TD="class: xl66, bgcolor: transparent"]Monthly
[/TD]
[TD="class: xl66, bgcolor: transparent"]Roster,
[/TD]
[TD="class: xl66, bgcolor: transparent"]East
[/TD]
[TD="class: xl66, bgcolor: transparent"]Coast
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Trailering
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team
[/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"]Roster
[/TD]
[TD="class: xl66, bgcolor: transparent"]of
[/TD]
[TD="class: xl66, bgcolor: transparent"]Trailer
[/TD]
[TD="class: xl66, bgcolor: transparent"]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]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Manifest
[/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"]Load
[/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"]Created
[/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"]Operator
[/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"]Consolidator
[/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"]Consignee
[/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"]Trailer
[/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"]LH
[/TD]
[TD="class: xl66, bgcolor: transparent"]Carrier
[/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"]Loaded
[/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"]Closed
[/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"]Departed
[/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"]Arrived
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, 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"]Ctns
[/TD]
[TD="class: xl66, bgcolor: transparent"]Pcs
[/TD]
[TD="class: xl66, bgcolor: transparent"]Lbs
[/TD]
[TD="class: xl66, bgcolor: transparent"]PU$
[/TD]
[TD="class: xl66, bgcolor: transparent"]Cons$
[/TD]
[TD="class: xl66, bgcolor: transparent"]LH$
[/TD]
[TD="class: xl66, bgcolor: transparent"]FSC
[/TD]
[TD="class: xl66, bgcolor: transparent"]Total
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Inv
[/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"]Spot
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, 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: xl68, bgcolor: #8db4e2, align: right"]1241103
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]John
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]Smith
[/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: xl68, bgcolor: #8db4e2, align: right"]7795
[/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: xl70, bgcolor: #00b050, align: right"]5800
[/TD]
[TD="class: xl71, bgcolor: #7030a0, align: right"]2/19/2014
[/TD]
[TD="class: xl72, bgcolor: #7030a0, align: right"]6:17
[/TD]
[TD="class: xl73, bgcolor: #7030a0"]PM
[/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: xl74, bgcolor: #7030a0, align: right"]5/26/2014 0:00
[/TD]
[TD="class: xl75, bgcolor: #7030a0, align: right"]10:56:00
[/TD]
[TD="class: xl73, bgcolor: #7030a0"]PM
[/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: xl76, bgcolor: #fabf8f, align: right"]5/26/2014 0:00
[/TD]
[TD="class: xl77, bgcolor: #fabf8f, align: right"]11:59:00
[/TD]
[TD="class: xl78, bgcolor: #fabf8f"]PM
[/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: xl70, bgcolor: #00b050"]FLY
[/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: xl79, bgcolor: red, align: right"]2/19/2014
[/TD]
[TD="class: xl80, bgcolor: yellow, align: right"]575
[/TD]
[TD="class: xl81, bgcolor: #948a54, align: right"]0
[/TD]
[TD="class: xl82, bgcolor: #ccc0da, align: right"]9121
[/TD]
[TD="class: xl83, bgcolor: #bfbfbf, align: right"]310.2
[/TD]
[TD="class: xl84, bgcolor: #ddd9c4, align: right"]2,736.30
[/TD]
[TD="class: xl85, bgcolor: #00b0f0, align: right"]837.51
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl86, bgcolor: red"]cartre
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]John
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]Smith-
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]Direct
[/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: xl87, bgcolor: #da9694"]E0163828
[/TD]
[TD="class: xl88, bgcolor: #92cddc, align: right"]415.52
[/TD]
[TD="class: xl89, bgcolor: #963634, align: right"]111.79
[/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: xl68, bgcolor: #8db4e2, align: right"]34561546
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]John
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]Smith
[/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: xl68, bgcolor: #8db4e2, align: right"]8854
[/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: xl70, bgcolor: #00b050, align: right"]7200
[/TD]
[TD="class: xl71, bgcolor: #7030a0, align: right"]2/19/2014
[/TD]
[TD="class: xl72, bgcolor: #7030a0, align: right"]6:17
[/TD]
[TD="class: xl73, bgcolor: #7030a0"]PM
[/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: xl74, bgcolor: #7030a0, align: right"]5/26/2014 0:00
[/TD]
[TD="class: xl75, bgcolor: #7030a0, align: right"]10:20:00
[/TD]
[TD="class: xl73, bgcolor: #7030a0"]PM
[/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: xl76, bgcolor: #fabf8f, align: right"]5/26/2014 0:00
[/TD]
[TD="class: xl77, bgcolor: #fabf8f, align: right"]11:30:00
[/TD]
[TD="class: xl78, bgcolor: #fabf8f"]PM
[/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: xl70, bgcolor: #00b050"]GROUND
[/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: xl79, bgcolor: red, align: right"]2/19/2014
[/TD]
[TD="class: xl80, bgcolor: yellow, align: right"]363
[/TD]
[TD="class: xl81, bgcolor: #948a54, align: right"]0
[/TD]
[TD="class: xl82, bgcolor: #ccc0da, align: right"]5142
[/TD]
[TD="class: xl83, bgcolor: #bfbfbf, align: right"]253.1
[/TD]
[TD="class: xl84, bgcolor: #ddd9c4, align: right"]3,456.23
[/TD]
[TD="class: xl85, bgcolor: #00b0f0, align: right"]951.26
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl86, bgcolor: red"]cartre
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]John
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]Smith-
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]Direct
[/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: xl87, bgcolor: #da9694"]E016242
[/TD]
[TD="class: xl88, bgcolor: #92cddc, align: right"]215.32
[/TD]
[TD="class: xl89, bgcolor: #963634, align: right"]213.56
[/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]
</TBODY>[/TABLE]


And here's what I need it to look like:
[TABLE="width: 779"]
<TBODY>[TR]
[TD="class: xl65, width: 56, bgcolor: transparent, align: right"]6/30/2014
[/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 95, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 194, bgcolor: transparent"][/TD]
[TD="width: 194, bgcolor: transparent"][/TD]
[TD="width: 32, bgcolor: transparent"][/TD]
[TD="width: 23, bgcolor: transparent"][/TD]
[TD="width: 31, bgcolor: transparent"][/TD]
[TD="width: 43, bgcolor: transparent"][/TD]
[TD="width: 37, bgcolor: transparent"][/TD]
[TD="width: 51, bgcolor: transparent"][/TD]
[TD="width: 43, bgcolor: transparent"][/TD]
[TD="width: 62, bgcolor: transparent"]Page 1 of 9
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]TraileringTeam
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]P.O. Box 123456
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]LosAngeles, CA 90051-5176
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]Phone(XXX)XXX-XXXX Fax (XXX)XXX-XXXX
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]Rosterof Trailer Manifests
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]B90-Smith Monthly Roster, East Coast
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Manifest #
[/TD]
[TD="class: xl67, bgcolor: transparent"]Created
[/TD]
[TD="class: xl67, bgcolor: transparent"]Consolidator
[/TD]
[TD="class: xl67, bgcolor: transparent"]Inv #
[/TD]
[TD="class: xl67, bgcolor: transparent"]Trailer
[/TD]
[TD="class: xl67, bgcolor: transparent"]Loaded
[/TD]
[TD="class: xl67, bgcolor: transparent"]Departed
[/TD]
[TD="class: xl67, bgcolor: transparent"]Ctns
[/TD]
[TD="class: xl67, bgcolor: transparent"]Pcs
[/TD]
[TD="class: xl67, bgcolor: transparent"]Lbs
[/TD]
[TD="class: xl67, bgcolor: transparent"]PU$
[/TD]
[TD="class: xl67, bgcolor: transparent"]Cons$
[/TD]
[TD="class: xl67, bgcolor: transparent"]LH$
[/TD]
[TD="class: xl67, bgcolor: transparent"]FSC
[/TD]
[TD="class: xl67, 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"]Consolidator
[/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: xl68, bgcolor: #8db4e2, align: right"]1241103
[/TD]
[TD="class: xl72, bgcolor: red, align: right"]2/19/2014
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]John Smith
[/TD]
[TD="class: xl80, bgcolor: #da9694"]E0163828
[/TD]
[TD="class: xl70, bgcolor: #00b050, align: right"]5800
[/TD]
[TD="class: xl83, bgcolor: #7030a0"]2/19/2014 6:17:00 PM
[/TD]
[TD="class: xl71, bgcolor: #fabf8f"]5/26/2014 12:00:00 AM 11:59:00 PM
[/TD]
[TD="class: xl73, bgcolor: yellow, align: right"]575
[/TD]
[TD="class: xl74, bgcolor: #948a54, align: right"]0
[/TD]
[TD="class: xl75, bgcolor: #ccc0da, align: right"]9121
[/TD]
[TD="class: xl81, bgcolor: #92cddc, align: right"]415.52
[/TD]
[TD="class: xl76, bgcolor: #bfbfbf, align: right"]310.2
[/TD]
[TD="class: xl77, bgcolor: #ddd9c4, align: right"]2,736.30
[/TD]
[TD="class: xl82, bgcolor: #963634, align: right"]111.79
[/TD]
[TD="class: xl78, bgcolor: #00b0f0, align: right"]837.51
[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #8db4e2, align: right"]7795
[/TD]
[TD="class: xl79, bgcolor: red"]cartre
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]John Smith- Direct
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: #00b050"]FLY
[/TD]
[TD="class: xl84, bgcolor: #7030a0"]5/26/2014 12:00:00 AM 10:56:00 PM
[/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]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #8db4e2, align: right"]34561546
[/TD]
[TD="class: xl72, bgcolor: red, align: right"]2/19/2014
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]John Smith
[/TD]
[TD="class: xl80, bgcolor: #da9694"]E016242
[/TD]
[TD="class: xl70, bgcolor: #00b050, align: right"]7200
[/TD]
[TD="class: xl83, bgcolor: #7030a0"]2/19/2014 6:17:00 PM
[/TD]
[TD="class: xl71, bgcolor: #fabf8f"]5/27/2014 12:00:00 AM 11:30:00 PM
[/TD]
[TD="class: xl73, bgcolor: yellow, align: right"]363
[/TD]
[TD="class: xl74, bgcolor: #948a54, align: right"]0
[/TD]
[TD="class: xl75, bgcolor: #ccc0da, align: right"]5142
[/TD]
[TD="class: xl81, bgcolor: #92cddc, align: right"]215.32
[/TD]
[TD="class: xl76, bgcolor: #bfbfbf, align: right"]253.1
[/TD]
[TD="class: xl77, bgcolor: #ddd9c4, align: right"]3,456.23
[/TD]
[TD="class: xl82, bgcolor: #963634, align: right"]213.56
[/TD]
[TD="class: xl78, bgcolor: #00b0f0, align: right"]951.26
[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #8db4e2, align: right"]8854
[/TD]
[TD="class: xl79, bgcolor: red"]cartre
[/TD]
[TD="class: xl69, bgcolor: #ffc000"]John Smith- Direct
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: #00b050"]GROUND
[/TD]
[TD="class: xl84, bgcolor: #7030a0"]5/27/2014 12:00:00 AM 10:20:00 PM
[/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]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]

In the 2 purple cells that have 12:00:00, I have NO idea where that part came from! It doesn't appear on the pre-text-to-columns sheet!

The block of data are all 9 rows long, all formatted exactly the same. I've written a macro to move the top section and the data headers to sheet 2 and to move the first block of data to sheet 2. But the report is 1,600 or so lines long and I'm thinking there's GOT to be a way to move all of the blocks to sheet 2, in sets of 2 rows.

Here's the code I have so far (I know it's really messy, so, if you can see any way to tweak it, I'd be grateful):
Code: 
Sub Roster()
'Roster Macro-JD 07012014
With Application
.ScreenUpdating = False
.EnableEvents = False
.Calculation = xlCalculationManual
.DisplayAlerts = False
End With
Sheets(2).Range("A1").Value = Sheets(1).Range("A1").Value
Sheets(2).Range("O1").Value = Range("Sheet1!B1") & " " & Range("Sheet1!C1") _
    & " " & Range("Sheet1!D1") & " " & Range("Sheet1!E1")
Sheets(2).Range("H2").Value = Range("Sheet1!A6") & Range("Sheet1!B6")
Sheets(2).Range("H3").Value = Range("Sheet1!A2") & Range("Sheet1!B2") _
    & " " & Range("Sheet1!C2") & " " & Range("Sheet1!D2")
Sheets(2).Range("H4").Value = Range("Sheet1!A3") & Range("Sheet1!B3") _
    & " " & Range("Sheet1!C3") & " " & Range("Sheet1!D3")
Sheets(2).Range("H5").Value = Range("Sheet1!A4") & " " & Range("Sheet1!B4") _
    & " " & Range("Sheet1!C4") & " " & Range("Sheet1!D4")
Sheets(2).Range("H6").Value = Range("Sheet1!A7") & " " & Range("Sheet1!B7") _
    & " " & Range("Sheet1!C7") & " " & Range("Sheet1!D7")
Sheets(2).Range("H7").Value = Range("Sheet1!A5") & Range("Sheet1!B5") _
    & " " & Range("Sheet1!C5") & " " & Range("Sheet1!D5") & " " & _
    Range("Sheet1!E5") & " " & Range("Sheet1!F5") & " " & Range("Sheet1!G5")
With Range("H2:H7")
    .HorizontalAlignment = xlCenter
End With
Sheets(2).Range("A9").Value = Range("Sheet1!A8") & " " & Range("Sheet1!B8")
Sheets(2).Range("A10").Value = Range("Sheet1!A9") & " " & Range("Sheet1!B9")
Sheets(2).Range("B9").Value = Range("Sheet1!A10")
Sheets(2).Range("B10").Value = Range("Sheet1!A11")
Sheets(2).Range("C9").Value = Range("Sheet1!A12")
Sheets(2).Range("C10").Value = Range("Sheet1!A13")
Sheets(2).Range("D9").Value = Range("Sheet1!A21") & " " & Range("Sheet1!B21")
Sheets(2).Range("D10").Value = Range("Sheet1!A22")
Sheets(2).Range("E9").Value = Range("Sheet1!A14")
Sheets(2).Range("E10").Value = Range("Sheet1!A15") & " " & Range("Sheet1!B15")
Sheets(2).Range("F9").Value = Range("Sheet1!A16")
Sheets(2).Range("F10").Value = Range("Sheet1!A17")
Sheets(2).Range("G9").Value = Range("Sheet1!A18")
Sheets(2).Range("G10").Value = Range("Sheet1!A19")
Range("Sheet1!A20:H20").Copy
    Sheets(2).Select
    Range("H9:O9").PasteSpecial
Sheets(2).Range("A12").Formula = "=(Sheet1!A23)"
Sheets(2).Range("A13").Formula = "=(Sheet1!A24)"
Sheets(2).Range("B12").Formula = "=(Sheet1!A29)"
Sheets(2).Range("B13").Formula = "=(Sheet1!A30)"
Sheets(2).Range("C12").Formula = "=(Sheet1!B23&Sheet1!C23)"
Sheets(2).Range("C13").Formula = "=(Sheet1!B30&Sheet1!C30&Sheet1!D30)"
Sheets(2).Range("D12").Formula = "=(Sheet1!A31)"
Sheets(2).Range("E12").Formula = "=(Sheet1!A28)"
Sheets(2).Range("E13").Formula = "=(Sheet1!A30)"
Sheets(2).Range("F12").Formula = "=(Sheet1!B25&Sheet1!C25&Sheet1!D25)"
Sheets(2).Range("F13").Formula = "=(Sheet1!A26&Sheet1!B26&Sheet1!C26)"
Sheets(2).Range("G12").Formula = "=(Sheet1!A27&Sheet1!B27&Sheet1!C27)"
Sheets(2).Range("H12").Formula = "=(Sheet1!B29)"
Sheets(2).Range("I12").Formula = "=(Sheet1!C29)"
Sheets(2).Range("J12").Formula = "=(Sheet1!D29)"
Sheets(2).Range("K12").Formula = "=(Sheet1!B31)"
Sheets(2).Range("L12").Formula = "=(Sheet1!E29)"
Sheets(2).Range("M12").Formula = "=(Sheet1!F29)"
Sheets(2).Range("N12").Formula = "=(Sheet1!C31)"
Sheets(2).Range("O12").Formula = "=(Sheet1!G29)"
With Application
.ScreenUpdating = True
.EnableEvents = True
.Calculation = xlCalculationAutomatic
.DisplayAlerts = True
End With
End Sub

I would be so happy for any help! I started on this yesterday morning and I'm not making any more progress. I guess I could give up, but now it's WAR, LOL!

Sorry for the long post, but I wanted to get all the info in here.

I posted this on another site yesterday, but they haven't been able to help yet, so I'm hoping you guys will see something they didn't. Trying to copy blocks of data from sheet 1 to sheet 2, but not in the same order

Thank you!!
Jenny
 
Last edited:

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You must log in or register to reply here.

Similar threads

S
  • Question Question
Help with combining 2 macros into 1
Replies
8
Views
248
MARK858
MARK858
Agnarr
  • Question Question
VBA problem with creating new sheets
Replies
0
Views
800
Agnarr
Agnarr
C
  • Solved
VBA Code to move Amount Due from individual sheets to a master sheet, and then copy information from the master sheet back to the individual sheets?
Replies
7
Views
378
Coyotex3
C
B
  • Question Question
Copying Data from Sheet 1 to Sheet 2 and adding rows- Code Needed
2 3 4
Replies
30
Views
1K
mumps
mumps
J
  • Question Question
Issues copying data to another sheet
Replies
4
Views
426
jynxy
J

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top