Scrubbing Invoice Data And Automating GL Coding

yehayahe

New Member
Joined
Jan 10, 2019
Messages
1
Good Afternoon,

I am learning to use Excel VBA and would like some help with a project. I'd like to write a subroutine or function that scans each line of Excel transportation invoice data for a unique identifying number (PO - 7 digits, SO - 8 digits) then outputs a GL code based on characteristics of the identifying number (ie. a PO # beginning with 31- would code as inbound freight for our Eau Claire, WI branch - GL Code: 3030.00.5201.00

Which VBA code should I use for a project like this?

Also, the identifying number could be contained within any of the three columns shown below:


<colgroup><col style="mso-width-source:userset;mso-width-alt:9472;width:194pt" width="259"> <col style="mso-width-source:userset;mso-width-alt:13165;width:270pt" width="360"> <col style="mso-width-source:userset;mso-width-alt:9764;width:200pt" width="267"> </colgroup><tbody>
[TD="class: xl63, width: 259"]Reference
[/TD]
[TD="class: xl63, width: 360"]Reference2[/TD]
[TD="class: xl63, width: 267"]Reference3[/TD]

[TD="class: xl63"]PO Number: RMA# 62742598 PORM 5[/TD]
[TD="class: xl63"]Order Number: RMA# 62742598 PORM 5336046[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM #5336483[/TD]
[TD="class: xl63"]Order Number: PORM #5336483[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 5336588[/TD]
[TD="class: xl63"]Order Number: PORM 5336588[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 6197080[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293073511[/TD]
[TD="class: xl63"]Order Number: 3188003[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG291771411[/TD]
[TD="class: xl63"]Order Number: 14481649[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292098811[/TD]
[TD="class: xl63"]Order Number: 4187688[/TD]
[TD="class: xl63"]Sales Order #: 14497125[/TD]

[TD="class: xl63"]PO Number: BG292718711[/TD]
[TD="class: xl63"]Order Number: 14513525[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292720211[/TD]
[TD="class: xl63"]Order Number: 14509939[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293044911[/TD]
[TD="class: xl63"]Order Number: 6197098[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292663511[/TD]
[TD="class: xl63"]Order Number: 14506161[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292868611[/TD]
[TD="class: xl63"]Order Number: 14513529[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293072911[/TD]
[TD="class: xl63"]Order Number: S/O 14523612 ** PO 6197093[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292531011[/TD]
[TD="class: xl63"]Order Number: 2937927[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: R#R5531324[/TD]
[TD="class: xl63"]Sales Order #: NA[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 3260943[/TD]
[TD="class: xl63"]Sales Order #: na[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292787711[/TD]
[TD="class: xl63"]Order Number: 3870412[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292789211[/TD]
[TD="class: xl63"]Order Number: 3188142[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292788311[/TD]
[TD="class: xl63"]Order Number: 1253933[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292943411[/TD]
[TD="class: xl63"]Order Number: W1F8750[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293086111[/TD]
[TD="class: xl63"]Order Number: 4311450[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292713511[/TD]
[TD="class: xl63"]Order Number: 5336389[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292712911[/TD]
[TD="class: xl63"]Order Number: 5763351[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292711811[/TD]
[TD="class: xl63"]Order Number: 1253164[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 1254006[/TD]
[TD="class: xl63"]Sales Order #: na[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292864211[/TD]
[TD="class: xl63"]Order Number: 1254008[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292933611[/TD]
[TD="class: xl63"]Order Number: 127678[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM#5336677[/TD]
[TD="class: xl63"]Order Number: PORM#5336677[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 1253970[/TD]
[TD="class: xl63"]Order Number: 1253970[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 4674826-4574824-46[/TD]
[TD="class: xl63"]Order Number: PORM 4674826-4574824-4674825[/TD]
[TD="class: xl63"]Customer Reference: RGA-291652[/TD]

[TD="class: xl63"]PO Number: 4268714-01[/TD]
[TD="class: xl63"]Order Number: 4268714-01[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 141066-00[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5336181[/TD]
[TD="class: xl63"]Order Number: 5336181[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 14502785 PO 6196805[/TD]
[TD="class: xl63"]Order Number: 14502785 PO# 6196805[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 46747600-00[/TD]
[TD="class: xl63"]Order Number: 52713[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6197121[/TD]
[TD="class: xl63"]Order Number: 6197121[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: RADUE[/TD]
[TD="class: xl63"]Order Number: RADUE[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: 4310736-00; 4310836-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: PORM#5336316[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2944028[/TD]
[TD="class: xl63"]Order Number: 2944028[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM#4675329[/TD]
[TD="class: xl63"]Order Number: PORM#4675329[/TD]
[TD="class: xl63"]Customer Reference: RGA# 092118bh2[/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: 2178381[/TD]
[TD="class: xl63"]Sales Order #: 2179071[/TD]

[TD="class: xl63"]PO Number: 6194079[/TD]
[TD="class: xl63"]Order Number: 373852-004[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 1253847[/TD]
[TD="class: xl63"]Sales Order #: 55030823 [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6196937[/TD]
[TD="class: xl63"]Order Number: 6196937[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5336310[/TD]
[TD="class: xl63"]Sales Order #: 55030824 [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 6196906
[/TD]
[TD="class: xl63"]Sales Order #: 14510770[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM#5336860[/TD]
[TD="class: xl63"]Order Number: PORM#5336860[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM#5336642[/TD]
[TD="class: xl63"]Order Number: PORM#5336642[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 6197016[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 2943972[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293796611[/TD]
[TD="class: xl63"]Order Number: 6197223[/TD]
[TD="class: xl63"]Customer Reference: 386576[/TD]

[TD="class: xl63"]PO Number: BG292188311[/TD]
[TD="class: xl63"]Order Number: 14503801[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292905711
[/TD]
[TD="class: xl63"]Order Number: 14517763[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293465811[/TD]
[TD="class: xl63"]Order Number: 14528593[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293534811[/TD]
[TD="class: xl63"]Order Number: 14534925[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293707011[/TD]
[TD="class: xl63"]Order Number: 14534610[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293519311[/TD]
[TD="class: xl63"]Order Number: PO # 2179038[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293459911[/TD]
[TD="class: xl63"]Order Number: 3567564[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293822311[/TD]
[TD="class: xl63"]Order Number: 434302[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293291911[/TD]
[TD="class: xl63"]Order Number: 3188310[/TD]
[TD="class: xl63"]Sales Order #: Q5620516[/TD]

[TD="class: xl63"]PO Number: BG293468111[/TD]
[TD="class: xl63"]Order Number: 3188366[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293213211[/TD]
[TD="class: xl63"]Order Number: 4315305[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293472411[/TD]
[TD="class: xl63"]Order Number: 3188297[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293334911[/TD]
[TD="class: xl63"]Order Number: 3870479[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293490311[/TD]
[TD="class: xl63"]Order Number: 3870472[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293488111[/TD]
[TD="class: xl63"]Order Number: 1254118[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293486811[/TD]
[TD="class: xl63"]Order Number: 4916889[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293863011[/TD]
[TD="class: xl63"]Order Number: 3870511[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293862111[/TD]
[TD="class: xl63"]Order Number: 5518059[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG292091211[/TD]
[TD="class: xl63"]Order Number: 5336086[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 53365871[/TD]
[TD="class: xl63"]Order Number: 53365871[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293837211[/TD]
[TD="class: xl63"]Order Number: 4319880[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293667711[/TD]
[TD="class: xl63"]Order Number: 4675460[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293248011[/TD]
[TD="class: xl63"]Order Number: E049973[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293246811[/TD]
[TD="class: xl63"]Order Number: 5336629[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293471011[/TD]
[TD="class: xl63"]Order Number: 1254140[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293153111[/TD]
[TD="class: xl63"]Order Number: RMA# 751694, RMA# 751696[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293456611[/TD]
[TD="class: xl63"]Order Number: 4675378[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293295311[/TD]
[TD="class: xl63"]Order Number: PORM#5336716[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293714511[/TD]
[TD="class: xl63"]Order Number: MULTI PORMs[/TD]
[TD="class: xl63"]Customer Reference: MULTI RGAs[/TD]

[TD="class: xl63"]PO Number: RMA #6799[/TD]
[TD="class: xl63"]Order Number: RMA #6799[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4313785-00; 4312527-00;[/TD]
[TD="class: xl63"]Order Number: 4313785-00; 4312527-00; 4311632-00; [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6197078[/TD]
[TD="class: xl63"]Order Number: 8622[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: PORM#5336662/5335844[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 373852-003[/TD]
[TD="class: xl63"]Order Number: 373852-003[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: PORM#5336472[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: 3187985[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: 4314428-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: 3188304[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM#5336710[/TD]
[TD="class: xl63"]Order Number: PORM#5336710[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM#5336510[/TD]
[TD="class: xl63"]Order Number: PORM#5336510[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179335[/TD]
[TD="class: xl63"]Order Number: 2179335[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 14541100[/TD]
[TD="class: xl63"]Order Number: 14541100[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 14549258[/TD]
[TD="class: xl63"]Order Number: 14549258[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 14552141[/TD]
[TD="class: xl63"]Order Number: 14552141[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179250[/TD]
[TD="class: xl63"]Order Number: 2179250[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 3567718[/TD]
[TD="class: xl63"]Order Number: 3567718[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2174611-06[/TD]
[TD="class: xl63"]Order Number: 2174611-06[/TD]
[TD="class: xl63"]Customer Reference: 2179450[/TD]

[TD="class: xl63"]PO Number: 3188402[/TD]
[TD="class: xl63"]Order Number: 3188402[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179434[/TD]
[TD="class: xl63"]Order Number: 2179434[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 8279090[/TD]
[TD="class: xl63"]Order Number: 8279090[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 9046186366[/TD]
[TD="class: xl63"]Order Number: 9046186366[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179137[/TD]
[TD="class: xl63"]Order Number: 2179137[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6197386[/TD]
[TD="class: xl63"]Order Number: 6197386[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5763460[/TD]
[TD="class: xl63"]Order Number: 5763460[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 1253523[/TD]
[TD="class: xl63"]Order Number: 1253523[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: Porm #5337032[/TD]
[TD="class: xl63"]Order Number: Porm #5337032[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: PORM#5337050[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 5337134[/TD]
[TD="class: xl63"]Order Number: PORM 5337134[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM#5337182[/TD]
[TD="class: xl63"]Order Number: PORM#5337182[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6197475[/TD]
[TD="class: xl63"]Order Number: 6197475[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: porm 4675650--4675648[/TD]
[TD="class: xl63"]Order Number: porm 4675650--4675648[/TD]
[TD="class: xl63"]Customer Reference: RGAs 18992--18987[/TD]

[TD="class: xl63"]PO Number: 4675541[/TD]
[TD="class: xl63"]Order Number: 4675541[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5336990[/TD]
[TD="class: xl63"]Order Number: 5336990[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG293570111[/TD]
[TD="class: xl63"]Order Number: PORM#5336835[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4324250-00[/TD]
[TD="class: xl63"]Order Number: 4324250-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 4675583[/TD]
[TD="class: xl63"]Order Number: PORM 4675583[/TD]
[TD="class: xl63"]Customer Reference: RGA R5531258[/TD]

[TD="class: xl63"]PO Number: 1454110[/TD]
[TD="class: xl63"]Order Number: 14541100[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO # 6033413[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 6197403
[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 318584[/TD]
[TD="class: xl63"]Order Number: 318584[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA
[/TD]
[TD="class: xl63"]Order Number: 4321023-00; 4317883-00; 4318821-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 4675462
[/TD]
[TD="class: xl63"]Order Number: PORM 4675462[/TD]
[TD="class: xl63"]Customer Reference: RGA W141860[/TD]

[TD="class: xl63"]PO Number: 8179061[/TD]
[TD="class: xl63"]Order Number: 381603[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 5336903[/TD]
[TD="class: xl63"]Order Number: PORM#5336903[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5212316[/TD]
[TD="class: xl63"]Order Number: 5212316[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5336585[/TD]
[TD="class: xl63"]Order Number: PORM#5336585[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: RMA 12855[/TD]
[TD="class: xl63"]Order Number: RMA# 12855[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 3188080[/TD]
[TD="class: xl63"]Order Number: 3188080[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 5336954[/TD]
[TD="class: xl63"]Order Number: PORM#5336954[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 5336518[/TD]
[TD="class: xl63"]Order Number: PORM 5336518[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2944303[/TD]
[TD="class: xl63"]Order Number: 2944303[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6034520[/TD]
[TD="class: xl63"]Sales Order #: NA[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 542381[/TD]
[TD="class: xl63"]Order Number: 4674569[/TD]
[TD="class: xl63"]Customer Reference: 542381[/TD]

[TD="class: xl63"]PO Number: RGA OI333844[/TD]
[TD="class: xl63"]Order Number: PORM 4675436[/TD]
[TD="class: xl63"]Customer Reference: RGA PI333844[/TD]

[TD="class: xl63"]PO Number: PORM 4675664[/TD]
[TD="class: xl63"]Order Number: PORM 4675664[/TD]
[TD="class: xl63"]Customer Reference: RGA -rma1463825[/TD]

[TD="class: xl63"]Order Number: 2179305[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2944220[/TD]
[TD="class: xl63"]Order Number: 2944220[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179371[/TD]
[TD="class: xl63"]Order Number: 2179371[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4675792[/TD]
[TD="class: xl63"]Order Number: 4675792[/TD]
[TD="class: xl63"]Sales Order #: 14560158[/TD]

[TD="class: xl63"]PO Number: 14563169[/TD]
[TD="class: xl63"]Order Number: 14563169[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 14563166[/TD]
[TD="class: xl63"]Order Number: 14563166[/TD]
[TD="class: xl63"]Sales Order #: 1254678[/TD]

[TD="class: xl63"]PO Number: 14560155[/TD]
[TD="class: xl63"]Order Number: 14560155[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 14563168[/TD]
[TD="class: xl63"]Order Number: 14563168[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4326755-00[/TD]
[TD="class: xl63"]Sales Order #: NA[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179544[/TD]
[TD="class: xl63"]Order Number: PO # 2179544[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179493[/TD]
[TD="class: xl63"]Order Number: 2179493[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6701800[/TD]
[TD="class: xl63"]Order Number: 6701800[/TD]
[TD="class: xl63"]Sales Order #: 12704[/TD]

[TD="class: xl63"]PO Number: 5336944[/TD]
[TD="class: xl63"]Order Number: 5336944[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 4916965[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 4916965[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5337143[/TD]
[TD="class: xl63"]Order Number: 5337143[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179547[/TD]
[TD="class: xl63"]Order Number: 2179547[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 1252845[/TD]
[TD="class: xl63"]Order Number: 1252845[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 4675703--4675702--[/TD]
[TD="class: xl63"]Order Number: PORM 4675703--4675702--4675704--4675[/TD]
[TD="class: xl63"]Customer Reference: RGA 0065278211[/TD]

[TD="class: xl63"]PO Number: 3567773[/TD]
[TD="class: xl63"]Order Number: 3567773[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4675818[/TD]
[TD="class: xl63"]Order Number: 14563165[/TD]
[TD="class: xl63"]Sales Order #: 4675818[/TD]

[TD="class: xl63"]PO Number: 1791900-00[/TD]
[TD="class: xl63"]Order Number: 1791900-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 5337267[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4317916-00; 4320519-00;[/TD]
[TD="class: xl63"]Order Number: 4317916-00; 4320519-00; 4317927-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 125384[/TD]
[TD="class: xl63"]Order Number: 125384[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5337012[/TD]
[TD="class: xl63"]Order Number: 318767[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: PORM#5336982 & 53368[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 3567677[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PO 9021258 SO 62757218[/TD]
[TD="class: xl63"]Order Number: PO 9021258; SO 62757218[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: 4323940-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: 4323742-00; 4323788-00; 4323053-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4675582[/TD]
[TD="class: xl63"]Order Number: 4675582[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM#5337133[/TD]
[TD="class: xl63"]Order Number: PORM#5337133[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 533127[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6197443[/TD]
[TD="class: xl63"]Order Number: 6197443[/TD]
[TD="class: xl63"]Customer Reference: P18069-002ARC[/TD]

[TD="class: xl63"]PO Number: 2177103[/TD]
[TD="class: xl63"]Order Number: 2177103[/TD]
[TD="class: xl63"]Customer Reference: 2179088[/TD]

[TD="class: xl63"]PO Number: 4188301[/TD]
[TD="class: xl63"]Order Number: RMA'S# 8400029872, 8400029856, 84000[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6194616[/TD]
[TD="class: xl63"]Order Number: 6194616[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PORM 4675819[/TD]
[TD="class: xl63"]Order Number: porm 4675819[/TD]
[TD="class: xl63"]Customer Reference: RGA 0065278891[/TD]

[TD="class: xl63"]PO Number: PO 6197653[/TD]
[TD="class: xl63"]Order Number: PO 6197653[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: RMA# 12855[/TD]
[TD="class: xl63"]Sales Order #: NA[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 2179600[/TD]
[TD="class: xl63"]Order Number: 2179600[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295020611[/TD]
[TD="class: xl63"]Order Number: 5336919[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295238011[/TD]
[TD="class: xl63"]Order Number: 2179434[/TD]
[TD="class: xl63"]Customer Reference: 2179697[/TD]

[TD="class: xl63"]Order Number: 5336832[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295427611[/TD]
[TD="class: xl63"]Order Number: 1254689[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295205911[/TD]
[TD="class: xl63"]Order Number: 5337563[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295205211[/TD]
[TD="class: xl63"]Order Number: 4675951[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295255511[/TD]
[TD="class: xl63"]Order Number: 1254825[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295221611[/TD]
[TD="class: xl63"]Order Number: 4917005[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295186611[/TD]
[TD="class: xl63"]Order Number: 4615858[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295284511[/TD]
[TD="class: xl63"]Order Number: 4188481[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 5337353[/TD]
[TD="class: xl63"]Order Number: 5337353[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 1254680[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 5335372[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]Order Number: 5337408[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: 4323788-00; 4329589-00; 4329500-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: NA[/TD]
[TD="class: xl63"]Order Number: PORM 4675925[/TD]
[TD="class: xl63"]Customer Reference: RGA rma-r56037901[/TD]

[TD="class: xl63"]PO Number: NA
[/TD]
[TD="class: xl63"]Order Number: 3188670[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4675725[/TD]
[TD="class: xl63"]Order Number: 4675725[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 1804346-00[/TD]
[TD="class: xl63"]Order Number: 1804346-00[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 73199-00[/TD]
[TD="class: xl63"]Sales Order #: NA[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Order Number: 14569796[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Order Number: 2944577[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Order Number: 14581035
[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Order Number: RGA# Q 5638100
[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Order Number: 6605402[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: PO 2179735[/TD]
[TD="class: xl63"]Order Number: PO 2179735[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 14579830[/TD]
[TD="class: xl63"]Order Number: 14579830[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 4676050
[/TD]
[TD="class: xl63"]Order Number: 14578754[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 1254678
[/TD]
[TD="class: xl63"]Order Number: 14563166[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: RM 5337719[/TD]
[TD="class: xl63"]Order Number: PORM#5337719[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: 6197940[/TD]
[TD="class: xl63"]Order Number: 6197940[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295870611[/TD]
[TD="class: xl63"]Order Number: 1255034
[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295626211[/TD]
[TD="class: xl63"]Order Number: 8279174
[/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl63"]PO Number: BG295836911[/TD]
[TD="class: xl63"]Order Number: RMA# 400015079
[/TD]
[TD="class: xl63"]
[/TD]

[TD="class: xl63"]PO Number: 6197962[/TD]
[TD="class: xl63"]Order Number: 1248117
[/TD]
[TD="class: xl63"]
[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

</tbody>
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,223,885
Messages
6,175,184
Members
452,615
Latest member
bogeys2birdies

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