Scrubbing Invoice Data And Automating GL Coding

yehayahe · Jan 10, 2019

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>

Scrubbing Invoice Data And Automating GL Coding

yehayahe

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

Scrubbing Invoice Data And Automating GL Coding

yehayahe

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock