Macro to select certain rows

T

THRASHER69

Board Regular
Joined
Mar 29, 2012
Messages
200
I am needing help with a macro to select the header and rows below till the next header is reached if column L is less than column J for the whole sheet which can be up to 5000 lines or more. Then copy all of those to a new sheet. Any help would be greatly appreciated. Here is part of the spreadsheet for a visual:

[TABLE="width: 1325"]
<TBODY>[TR]
[TD="class: xl22, width: 65, bgcolor: #993300"]Product number
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 42, bgcolor: #993300"]Finish date
[/TD]
[TD="class: xl22, width: 54, bgcolor: #993300"]Planned Qty
[/TD]
[TD="class: xl22, width: 56, bgcolor: #993300"]Mfg U/M
[/TD]
[TD="class: xl22, width: 22, bgcolor: #993300"]Lvl
[/TD]
[TD="class: xl22, width: 96, bgcolor: #993300"]Component
[/TD]
[TD="class: xl22, width: 255, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Required Qty
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Bas U/M
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Available
[/TD]
[TD="class: xl22, width: 94, bgcolor: #993300"]Drawing Number
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"]26010000
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"]70512
[/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]21009428
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]E-RING FOR T164 SHAFT & HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]180
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1324
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]PF
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901040
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]E-RING F/HCV LOCK PIN ASSY-SS
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]99
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901005
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]SP'L 5/8"SAFETY HINGE BOLT
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]144
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901010
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]HANDLE ONLY - HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]94
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]8116
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901020
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]LOCKING PIN FOR HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]57
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26901020
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901021
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]GREASE FITTING STRAP CAP - HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]40
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]851
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901028
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"LOCK NUT FOR HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]60
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]394
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]PF
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901030
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2"*5"LOCKING EYEBOLT FOR HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]60
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]293
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26901030
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901031
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]WASHER FOR 1/2"*5"HCV EYEBOLT
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]60
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]76
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]PF
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901033
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2"20NF*2.5"HX HD BOLT-PLATED
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]60
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]300
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901036
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]HOPPER CAR VALVE BODY
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58"]7
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26901036
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901037
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]HOPPER CAR VALVE SHAFT
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]74
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26901037
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901050
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]SPRING FOR HCV PIN
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]157
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901900
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]HOPPER CAR VALVE FLAPPER PLATE
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]48
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26901900
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26909020
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]LOCKING MECHANISM FOR HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]60
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]269
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26909020
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26909070
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"SAFETY EYEBOLT ASSY - HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58"]0
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26909070
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99800020
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/8"GREASE ZERK (THD TYPE)
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]40
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]589
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99903260
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]#326 BN O'RING - 1.25"UNION
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]40
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]194
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99996010
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2"LOCK WASHER
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]40
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]3703
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99996204
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]9/16"WASHER (13/16"OD)
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]102
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99997400
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/16"*1"DRIV-LOK PIN.TYPE E
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]5127
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99998300
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2"*1"LG BOLT
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]40
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]416
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]HOPPER CAR VALVE *LESS COVER*
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99999020
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2"LOCK NUT W/NYLON INSERT
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]120
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1210
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl22, width: 65, bgcolor: #993300"]Product number
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 42, bgcolor: #993300"]Finish date
[/TD]
[TD="class: xl22, width: 54, bgcolor: #993300"]Planned Qty
[/TD]
[TD="class: xl22, width: 56, bgcolor: #993300"]Mfg U/M
[/TD]
[TD="class: xl22, width: 22, bgcolor: #993300"]Lvl
[/TD]
[TD="class: xl22, width: 96, bgcolor: #993300"]Component
[/TD]
[TD="class: xl22, width: 255, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Required Qty
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Bas U/M
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Available
[/TD]
[TD="class: xl22, width: 94, bgcolor: #993300"]Drawing Number
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"]26909070
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]3/4"SAFETY EYEBOLT ASSY - HCV
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]3/4"SAFETY EYEBOLT ASSY - HCV
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"]70312
[/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26909070
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]3/4"SAFETY EYEBOLT ASSY - HCV
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]26901001
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]MOD 3/4"X6.75" EYEBOLT- HCV
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]62
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]26909070
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]3/4"SAFETY EYEBOLT ASSY - HCV
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]10909101
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"-10NC HEAVY HEX NUT-HHS
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1164
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]PF
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]3/4"SAFETY EYEBOLT ASSY - HCV
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99997201
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]SPRING PIN 3/16"*1.25"-BRONCO
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]407
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]3/4"SAFETY EYEBOLT ASSY - HCV
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99996220
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"WASHER (2"OD*1/8"THK)
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]236
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl22, width: 65, bgcolor: #993300"]Product number
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 42, bgcolor: #993300"]Finish date
[/TD]
[TD="class: xl22, width: 54, bgcolor: #993300"]Planned Qty
[/TD]
[TD="class: xl22, width: 56, bgcolor: #993300"]Mfg U/M
[/TD]
[TD="class: xl22, width: 22, bgcolor: #993300"]Lvl
[/TD]
[TD="class: xl22, width: 96, bgcolor: #993300"]Component
[/TD]
[TD="class: xl22, width: 255, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Required Qty
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Bas U/M
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Available
[/TD]
[TD="class: xl22, width: 94, bgcolor: #993300"]Drawing Number
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"]29510021
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.25"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG)
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.25"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"]70212
[/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"]6
[/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.25"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909305
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"PIPE PLUG F/ORG
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]6
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1067
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.25"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29600527
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.25"NITRILE V-RING PKG-PCSB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]6
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]SET
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]438
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.25"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29903070
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]CAP F/PCSB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]6
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]189
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29903070
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.25"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29903090
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1"-1.31" HPLUG BODY
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]6
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]13
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29903090
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.25"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29908360
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.25"PCSB SPLIT BUSHING
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]12
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]474
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29908360
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.25"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99800021
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/4" NPT GREASE ZERK
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]6
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1326
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl22, width: 65, bgcolor: #993300"]Product number
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 42, bgcolor: #993300"]Finish date
[/TD]
[TD="class: xl22, width: 54, bgcolor: #993300"]Planned Qty
[/TD]
[TD="class: xl22, width: 56, bgcolor: #993300"]Mfg U/M
[/TD]
[TD="class: xl22, width: 22, bgcolor: #993300"]Lvl
[/TD]
[TD="class: xl22, width: 96, bgcolor: #993300"]Component
[/TD]
[TD="class: xl22, width: 255, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Required Qty
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Bas U/M
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Available
[/TD]
[TD="class: xl22, width: 94, bgcolor: #993300"]Drawing Number
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"]29510061
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.5"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.5"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"]70212
[/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"]25
[/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.5"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909305
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"PIPE PLUG F/ORG
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]25
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1067
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.5"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29600567
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.5"NITRILE V-RING PKG-PCSB (
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]25
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]SET
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]221
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.5"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29903070
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]CAP F/PCSB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]25
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]189
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29903070
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.5"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29903100
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.5" HPLUG BODY
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]25
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]42
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29903100
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.5"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29908370
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.5"PCSB SPLIT BUSHING
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]50
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1329
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29908370
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]1.5"PCSB UPPER GLAND ASSY (HPLUG) W/NBR V-PKG
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99800021
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/4" NPT GREASE ZERK
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]25
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1326
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl22, width: 65, bgcolor: #993300"]Product number
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 42, bgcolor: #993300"]Finish date
[/TD]
[TD="class: xl22, width: 54, bgcolor: #993300"]Planned Qty
[/TD]
[TD="class: xl22, width: 56, bgcolor: #993300"]Mfg U/M
[/TD]
[TD="class: xl22, width: 22, bgcolor: #993300"]Lvl
[/TD]
[TD="class: xl22, width: 96, bgcolor: #993300"]Component
[/TD]
[TD="class: xl22, width: 255, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Required Qty
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Bas U/M
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Available
[/TD]
[TD="class: xl22, width: 94, bgcolor: #993300"]Drawing Number
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"]29539997ATX
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"]70212
[/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29905000
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]6 WAY CROSS F/HPLUG LEAK DET
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58"]0
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29905000
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29512ATX
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2" PRESSURE SWITCH F/SB LEAK
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]74
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]PF
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]37300104W
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"2000# SS BV-2PC/SEAL WELDE
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]375
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]32960424
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"2500CWP FIG300 HEX NUT
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]53
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]32960424
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]32960640
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"4M 300 TL SUB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]88
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]32960640
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]32960657
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"4M 300 THD SUB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]88
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]32960657
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99902151
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]#215 VITON O'RING - 3/4"UNION
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]162
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl24, width: 96, bgcolor: transparent"]1.29E+23
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4" NPT X 2" SCH. 80 NIP
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]102
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]241
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]PF
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909302
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2"NPT PIPE PLUG F/ORG
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]102
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]688
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909305
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/4"PIPE PLUG F/ORG
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]153
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1067
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29511ATX-TAG
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]LABEL F/EXP-PROOF PRESSURE SWI
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]111
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29511000-TAG
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]BX-LD
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]BOX: LD BOX W/ INSERTS
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58"]45
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]STUFF BOX LEAK DETECTOR ONLY-1500 PSI (W/18 PSI EXP SWITCH)
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]129SE001
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2"X3/4" SCH. 80 SWAGE NIPPLE
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]51
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]93
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl22, width: 65, bgcolor: #993300"]Product number
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 452, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 42, bgcolor: #993300"]Finish date
[/TD]
[TD="class: xl22, width: 54, bgcolor: #993300"]Planned Qty
[/TD]
[TD="class: xl22, width: 56, bgcolor: #993300"]Mfg U/M
[/TD]
[TD="class: xl22, width: 22, bgcolor: #993300"]Lvl
[/TD]
[TD="class: xl22, width: 96, bgcolor: #993300"]Component
[/TD]
[TD="class: xl22, width: 255, bgcolor: #993300"]Name
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Required Qty
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Bas U/M
[/TD]
[TD="class: xl22, width: 58, bgcolor: #993300"]Available
[/TD]
[TD="class: xl22, width: 94, bgcolor: #993300"]Drawing Number
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"]2980316B
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"]70212
[/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11600169H
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.5"COMP"G"TOP CONE (PC) R3
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]24
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1447
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]PF
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11620161
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.5"HSN(HNBR) DOME PKG (PC)
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]24
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]3139
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11901070
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]BODY F/DPSB W/COMP BOLT.NUT&RI
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1038
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11901160
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]LOWER GLAND F/SB'S (PATT# 296)
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1582
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]11991160
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11908121
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.37-1.5"COMP RING F/DP-PATT#4
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1770
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]6551
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11908156
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.5"LARGE BRONZE SPLIT RING-DO
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1124
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]11908156
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11908158
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]ORG ADAPTER RING F/DOME PKG
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]67
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]11908158
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11908159
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]#330 SQ BN O'RING-ORG W/DOME P
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]528
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]11908159
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29906080
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.5"HTD LWR SPLIT BUSH W/RET
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]36
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29906080
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909011
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"*4.5"BOLT F/IVSB.IVDP.SB-D
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]16
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]13992
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909013
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"*6"BOLT F/SBT
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]16
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1240
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909103
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"HEAVY HX NUT F/DPSB.SB.WFM
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]32
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]18251
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909104
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"HVY SQUARE NUT F/ALL SB'S
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]32
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]12851
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909201
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"LOCK WASHER F/DPSB.WFM
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]96
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]32728
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909202
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"FLAT WASHER F/ALL SB'S
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]32
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]30109
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909302
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1/2"NPT PIPE PLUG F/ORG
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]688
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11902031
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.37-1.5"LUB CAP (PATT #105A)
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1800
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]11902031
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11901021
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]1.37-1.5"LUB BODY W/ZERK
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]128
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]11901021
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909001
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/8"-16*2"CAP SCREW F/LUB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]16
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]7000
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909100
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/8"SQUARE NUT F/LUB & ORG
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]16
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8538
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]11909200
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]3/8"INT-EXT LOCK WASHER F/LUB.
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]16
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]6754
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29903080
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]PCSB ADAPTER SPOOL
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29903080
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29903151
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]2.5"8RD PCSB BASE
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29903151
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29908340
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]LH SPRING - PCSB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]677
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29908340
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29908350
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]RH SPRING - PCSB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]521
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29908350
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29909208
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"*1.75"BOLT F/PCSB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]48
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]3403
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29909207
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]5/8"*2"BOLT F/PCSB
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]48
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]3293
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99901461
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]#146 VITON O'RING-PCSB ADAPTER
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]365
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99902521
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]#252 VITON O'RING-PCSB BASE
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]879
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]99904301
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]#430 VITON O'RING - DPSB BASE
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1944
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29908351
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]PCSB FLAPPER
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1417
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29908351
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29908352
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]PCSB FLAPPER WEAR PAD
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]8
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1169
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"]29908352
[/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29908353
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]#10-24*.75 SOC HD CAP SCREW
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]16
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1769
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 65, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 452, bgcolor: transparent"]2.5"8RD PCSB W/1.5" DOME/"G" BASE CONES & LUB UPPER GLAND
[/TD]
[TD="class: xl23, width: 42, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl23, width: 22, bgcolor: transparent"]1
[/TD]
[TD="class: xl23, width: 96, bgcolor: transparent"]29908354
[/TD]
[TD="class: xl23, width: 255, bgcolor: transparent"]#10-24 NYLON LOCK HEX NUT
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]16
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]EA
[/TD]
[TD="class: xl23, width: 58, bgcolor: transparent"]1771
[/TD]
[TD="class: xl23, width: 94, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]

Sorry for the size. I wasn't sure how to make it smaller

Thank you
 
Sort by date Sort by votes
Based on the data sample you posted, what should your end result look like.

If I understand, it would be two sheets, each with two components and headers?

Any particular sheet naming convention?
 
Upvote 0
Two sheets is basically what I'm after. I will try to explain a bit better using the above example. I'm looking for a macro that will check column with the header "Available" (Column L) for the whole sheet. It will check each number under "Available" (Column L) and see if it is less than the numbers under the column "Required Qty"(Column J). Under the 1st and 5th headers in the above example, both have quantities in column L that are less than the quantities in column J. The 2nd, 3rd, 4th, and 6th headers do not have quantities under column L that are less than the quantities in column J. Here is where it can go one of two ways.
1. I need the macro to check the whole sheet and cut the entire header and all the rows underneath until it reaches the next header for the ones that column "L" is less than column "J" and paste them to a new sheet named "Low Inventory" which in the above example would be the 1st and 5th headers and the rows underneath them, leaving the 2nd, 3rd, 4th, and 6th headers and data on the original sheet
2. I need the macro to check the whole sheet and delete the header and all the rows underneath the header until it reaches the next header for the ones that column "L" is equal to or greater than column "J". In the above example the macro would delete the 2nd, 3rd, 4th, and 6th headers and the data underneath them leaving the 1st and 5th headers and the data underneath on the original sheet.
I want to basically separate the ones that do not have enough inventory from the ones that do keeping the headers attached for each one. Either way I listed will work.

Hope this explains what I'm asking for a little better.

Thank you

THRASHER
 
Upvote 0
Warship said:
Based on the data sample you posted, what should your end result look like.

If I understand, it would be two sheets, each with two components and headers?

Any particular sheet naming convention?
Click to expand...
I meant I wanted you to manually create the sheets and post them like you did your sample data.
I think I get it now but... "a picture = 1000 words"
 
Upvote 0
see if this is what you're looking for...
Code: 
Sub Inventory()
    Dim found As Range
    Dim rgSource As Range
    Dim shSource As Worksheet
    Dim shDestin As Worksheet
    Dim shLo As Worksheet
    Dim shOk As Worksheet
    Dim bLow As Boolean
    Dim nextRow As Long
    Dim sShSource As String
    Dim i As Long
    
    Application.ScreenUpdating = False
    
    Application.DisplayAlerts = False
    On Error Resume Next
    Sheets("Low Inventory").Delete
    Sheets("Okay Inventory").Delete
    On Error GoTo 0
    Application.DisplayAlerts = True
    
    Sheets.Add After:=Sheets(Sheets.Count)
    ActiveSheet.Name = "Low Inventory"
    Sheets.Add After:=Sheets(Sheets.Count)
    ActiveSheet.Name = "Okay Inventory"
    
    Set shSource = Sheets("Sheet1") 'change to suit
    Set shLo = Sheets("Low Inventory")
    Set shOk = Sheets("Okay Inventory")
    
    shSource.Activate
    shSource.Rows(1).Copy
    shLo.Cells(1, 1).PasteSpecial Paste:=xlPasteColumnWidths
    shOk.Cells(1, 1).PasteSpecial Paste:=xlPasteColumnWidths
    Application.CutCopyMode = False
    
    Set found = shSource.Range("L:L").Find("Available", Range("L1"), , xlWhole)
    Do While Not found Is Nothing
        If found.Row = 1 Then
            Set rgSource = shSource.Cells(1, 1).CurrentRegion
        Else
            Set rgSource = shSource.Rows("1:" & found.Row - 1)
        End If
        bLow = False
        For i = 2 To rgSource.Rows.Count
            If rgSource.Cells(i, "L") < rgSource.Cells(i, "J") Then
                bLow = True
                Exit For
            End If
        Next i
        If bLow Then
            Set shDestin = shLo
        Else
            Set shDestin = shOk
        End If
        nextRow = shDestin.Cells(1, 1).CurrentRegion.Rows.Count
        If nextRow > 1 Then nextRow = nextRow + 1
        rgSource.Copy shDestin.Cells(nextRow, 1)
        rgSource.EntireRow.Delete
        Set found = shSource.Range("L:L").Find("Available", Range("L1"), , xlWhole)
    Loop
    
    sShSource = shSource.Name
    Application.DisplayAlerts = False
    shSource.Delete
    Application.DisplayAlerts = True
    shOk.Name = sShSource
End Sub
 
Upvote 0
Wardhip,

I will give it a go when I get back to work Monday. If that's not what I was looking for I will create and post the before and after sheets for you. I will let you know either way.

I really appreciate the help!

THRASHER
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
VBA to extract row data to sheet and update data set
Replies
0
Views
971
justatroy
J
C
  • Solved
VBA Check if value in Sheet1 exists in Sheets(2-40), then copy found values from sheet 1 to sheet(2-40)
2
Replies
13
Views
2K
CobusVanWyk
C
T
  • Solved
Please help me get rid of the negative percentages.
Replies
4
Views
619
StephenCrump
S
U
  • Question Question
VBA FormulaArray Syntax/AutoFill/Set Ranges
Replies
2
Views
905
UlyssesFR
U
T
  • Question Question
Marco to Filter and Copy Multiple Rows
Replies
2
Views
395
THRASHER69
T

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