Copy data from report header to each transaction.

LearnVBA83

Board Regular
Joined
Dec 1, 2016
Messages
113
Office Version
  1. 365
Platform
  1. Windows
Hi VBA SuperUsers,

I've converted a txt file to excel and as many of you know the report headers are repeated in my excel document based on each change in page number on the original txt file. What I would like to do is take one piece of information from the header (the bank lockbox) and paste it beside each transaction on each page in excel. The trick is the lock box numbers do change within the title and there is no consistency. So is this possible with a macro. It would basically be saying copy Lockbox number and paste by each transaction until change in page then copy and paste the next lockbox number by each transaction.... etc. Once I figure out how to get the lockbox from the title beside each transaction, I will have the macro delete all of the report headings to give me a more manageable data set. Hopefully this will make since. It's hard to explain without being able to attach an example. For the time being below is a paste of what I have. This is only the first 3 pages out of a bunch of pages in this excel file. The bold lockboxes in column F are examples of what I want to paste beside each transaction. As you can see it changes in F57. Column K is not in the report but is an example of what I would like for the macro to do. Any help would be greatly appreciated. I've worked on this half the day and i'm getting nowhere. Thanks so much for anyone willing to help

[TABLE="width: 1078"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]RUN DATE: 0[/TD]
[TD="align: right"]01/01/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]CompanyName-EBS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]PAGE[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]DEPOSIT DATE[/TD]
[TD]: 01/01/17[/TD]
[TD][/TD]
[TD]L[/TD]
[TD]OCKBOX REPORT - B[/TD]
[TD]OX 0213[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]FRO[/TD]
[TD]M BankName, N.A.[/TD]
[TD="align: right"]21000089[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]CHK NBR CH[/TD]
[TD]K ACCT NBR[/TD]
[TD]CHK ABA #[/TD]
[TD]CHECK AMT[/TD]
[TD]INVOICE AMT[/TD]
[TD]INVOICE[/TD]
[TD]# CUST #[/TD]
[TD]BATCH[/TD]
[TD]SEQ#[/TD]
[TD]SYS SEQ #[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]2659[/TD]
[TD="align: right"]1361297[/TD]
[TD="align: right"]322273379[/TD]
[TD="align: right"]$2,070.25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]10001[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,070.25[/TD]
[TD]H4105631[/TD]
[TD="align: right"]8.96393E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]10001[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: right"]3272[/TD]
[TD="align: right"]898478011[/TD]
[TD="align: right"]322271627[/TD]
[TD="align: right"]$5,279.02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]10002[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,279.02[/TD]
[TD]H4083305[/TD]
[TD="align: right"]8.18271E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD]10002[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]3489[/TD]
[TD="align: right"]3244286245[/TD]
[TD="align: right"]122000247[/TD]
[TD="align: right"]$1,329.36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD]10003[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,329.36[/TD]
[TD]H4122275[/TD]
[TD="align: right"]9.29505E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD]10003[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]23979[/TD]
[TD="align: right"]1064174530[/TD]
[TD="align: right"]122037760[/TD]
[TD="align: right"]$2,765.42[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD]10004[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,765.42[/TD]
[TD]H4131700[/TD]
[TD="align: right"]9.43587E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD]10004[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD="align: right"]8375[/TD]
[TD="align: right"]202001461[/TD]
[TD="align: right"]121144311[/TD]
[TD="align: right"]$634.06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD]10005[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$634.06[/TD]
[TD]H4062609[/TD]
[TD="align: right"]2281871002[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD]10005[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD="align: right"]7861[/TD]
[TD="align: right"]8915058831[/TD]
[TD="align: right"]122000247[/TD]
[TD="align: right"]$1,658.94[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]11[/TD]
[TD]10006[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,658.94[/TD]
[TD]H4127782[/TD]
[TD="align: right"]9.36098E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[TD]10006[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD="align: right"]5596[/TD]
[TD="align: right"]206489841[/TD]
[TD="align: right"]322271724[/TD]
[TD="align: right"]$4,472.57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]13[/TD]
[TD]10007[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,472.57[/TD]
[TD]H3892726[/TD]
[TD="align: right"]8.9737E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]14[/TD]
[TD]10007[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD="align: right"]11460[/TD]
[TD="align: right"]20102745[/TD]
[TD="align: right"]122243884[/TD]
[TD="align: right"]$4,575.43[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]15[/TD]
[TD]10008[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,575.43[/TD]
[TD]H4132901[/TD]
[TD="align: right"]9.44716E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]16[/TD]
[TD]10008[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD="align: right"]7401[/TD]
[TD="align: right"]729009513[/TD]
[TD="align: right"]122000661[/TD]
[TD="align: right"]$4,253.57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17[/TD]
[TD]10009[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,253.57[/TD]
[TD]H4077731[/TD]
[TD="align: right"]8.00785E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18[/TD]
[TD]10009[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD="align: right"]4099[/TD]
[TD="align: right"]3890785494[/TD]
[TD="align: right"]322271627[/TD]
[TD="align: right"]$1,095.27[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19[/TD]
[TD]10010[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,095.27[/TD]
[TD]H4092838[/TD]
[TD="align: right"]8.46579E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20[/TD]
[TD]10010[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD="align: right"]9888[/TD]
[TD="align: right"]1790201431[/TD]
[TD="align: right"]122000661[/TD]
[TD="align: right"]$1,039.22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]21[/TD]
[TD]10011[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,039.22[/TD]
[TD]H4118157[/TD]
[TD="align: right"]9.20678E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]22[/TD]
[TD]10011[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD="align: right"]21420[/TD]
[TD="align: right"]102549125[/TD]
[TD="align: right"]43400036[/TD]
[TD="align: right"]$11,051.26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]23[/TD]
[TD]10012[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$11,051.26[/TD]
[TD]H4122172[/TD]
[TD="align: right"]9.29321E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]24[/TD]
[TD]10012[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD="align: right"]3491[/TD]
[TD="align: right"]1048571536[/TD]
[TD="align: right"]43000096[/TD]
[TD="align: right"]$6,476.40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]25[/TD]
[TD]10013[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,476.40[/TD]
[TD]H4104745[/TD]
[TD="align: right"]8.9409E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]26[/TD]
[TD]10013[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD="align: right"]9036[/TD]
[TD="align: right"]1515196[/TD]
[TD="align: right"]43403224[/TD]
[TD="align: right"]$7,066.06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]27[/TD]
[TD]10014[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,066.06[/TD]
[TD]H4126046[/TD]
[TD="align: right"]9.34363E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]28[/TD]
[TD]10014[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD="align: right"]17397[/TD]
[TD="align: right"]1416018412[/TD]
[TD="align: right"]243374218[/TD]
[TD="align: right"]$27,891.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]29[/TD]
[TD]10015[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$27,891.00[/TD]
[TD]H4120807[/TD]
[TD="align: right"]9.2538E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]30[/TD]
[TD]10015[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD="align: right"]48713[/TD]
[TD="align: right"]1059742101[/TD]
[TD="align: right"]41215032[/TD]
[TD="align: right"]$5,442.97[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]31[/TD]
[TD]10016[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,442.97[/TD]
[TD]H4118888[/TD]
[TD="align: right"]9.21783E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]32[/TD]
[TD]10016[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]104011837[/TD]
[TD="align: right"]243374234[/TD]
[TD="align: right"]$1,831.24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]33[/TD]
[TD]10017[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,831.24[/TD]
[TD]H4124698[/TD]
[TD="align: right"]9.33053E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]34[/TD]
[TD]10017[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD="align: right"]12580[/TD]
[TD="align: right"]130600620[/TD]
[TD="align: right"]43400036[/TD]
[TD="align: right"]$3,738.58[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]35[/TD]
[TD]10018[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]42[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$3,738.58[/TD]
[TD]H4124353[/TD]
[TD="align: right"]9.32755E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]36[/TD]
[TD]10018[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]43[/TD]
[TD="align: right"]9541[/TD]
[TD="align: right"]205009574[/TD]
[TD="align: right"]31100102[/TD]
[TD="align: right"]$6,899.02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]37[/TD]
[TD]10019[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,899.02[/TD]
[TD]H4085675[/TD]
[TD="align: right"]8.24415E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]38[/TD]
[TD]10019[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD="align: right"]26540[/TD]
[TD="align: right"]1.39E+12[/TD]
[TD="align: right"]31309123[/TD]
[TD="align: right"]$9,117.60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]39[/TD]
[TD]10020[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$9,117.60[/TD]
[TD]H4087670[/TD]
[TD="align: right"]8.30057E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]40[/TD]
[TD]10020[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]47[/TD]
[TD="align: right"]8233[/TD]
[TD="align: right"]210261079[/TD]
[TD="align: right"]31100102[/TD]
[TD="align: right"]$17,902.10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]41[/TD]
[TD]10021[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$17,902.10[/TD]
[TD]H4125474[/TD]
[TD="align: right"]9.34164E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]42[/TD]
[TD]10021[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD="align: right"]10037[/TD]
[TD="align: right"]290548801[/TD]
[TD="align: right"]31301422[/TD]
[TD="align: right"]$3,733.45[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]43[/TD]
[TD]10022[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$3,733.45[/TD]
[TD]H4130919[/TD]
[TD="align: right"]9.4291E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]44[/TD]
[TD]10022[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]51[/TD]
[TD="align: right"]3763[/TD]
[TD="align: right"]2524179175[/TD]
[TD="align: right"]122105744[/TD]
[TD="align: right"]$166.80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]45[/TD]
[TD]10023[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]52[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$166.80[/TD]
[TD]H4088456[/TD]
[TD="align: right"]8.33813E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]46[/TD]
[TD]10023[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]53[/TD]
[TD="align: right"]59690[/TD]
[TD="align: right"]12534405[/TD]
[TD="align: right"]122100024[/TD]
[TD="align: right"]$2,458.87[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]47[/TD]
[TD]10024[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,458.87[/TD]
[TD]H4058725[/TD]
[TD="align: right"]716111001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]48[/TD]
[TD]10024[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD="align: right"]9129[/TD]
[TD="align: right"]2502039213[/TD]
[TD="align: right"]122105744[/TD]
[TD="align: right"]$2,219.49[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]49[/TD]
[TD]10025[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]56[/TD]
[TD] RUN DATE: 0[/TD]
[TD="align: right"]01/01/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]CompanyName-EBS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]PAGE[/TD]
[TD]2[/TD]
[TD]OX 0213[/TD]
[/TR]
[TR]
[TD]57[/TD]
[TD]DEPOSIT DATE[/TD]
[TD]: 01/01/17[/TD]
[TD][/TD]
[TD]L[/TD]
[TD]OCKBOX REPORT - B[/TD]
[TD]OX 4777[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]58[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]FRO[/TD]
[TD]M BankName, N.A.[/TD]
[TD="align: right"]21000089[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]60[/TD]
[TD]CHK NBR CH[/TD]
[TD]K ACCT NBR[/TD]
[TD]CHK ABA #[/TD]
[TD]CHECK AMT[/TD]
[TD]INVOICE AMT[/TD]
[TD]INVOICE[/TD]
[TD]# CUST #[/TD]
[TD]BATCH[/TD]
[TD]SEQ#[/TD]
[TD]SYS SEQ #[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]62[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,219.49[/TD]
[TD]H4081107[/TD]
[TD="align: right"]8.12324E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50[/TD]
[TD]10025[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]63[/TD]
[TD="align: right"]14095[/TD]
[TD="align: right"]6521800043[/TD]
[TD="align: right"]101000695[/TD]
[TD="align: right"]$2,950.45[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]51[/TD]
[TD]10026[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]64[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,950.45[/TD]
[TD]H4085573[/TD]
[TD="align: right"]8.24301E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]52[/TD]
[TD]10026[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]65[/TD]
[TD="align: right"]78141[/TD]
[TD="align: right"]653245043[/TD]
[TD="align: right"]122100024[/TD]
[TD="align: right"]$16,272.20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]53[/TD]
[TD]10027[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]66[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$16,272.20[/TD]
[TD]H4073349[/TD]
[TD="align: right"]8.00255E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]54[/TD]
[TD]10027[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]67[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]869196589[/TD]
[TD="align: right"]122100024[/TD]
[TD="align: right"]$3,541.32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]55[/TD]
[TD]10028[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$3,541.32[/TD]
[TD]H3950057[/TD]
[TD="align: right"]9.49047E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]56[/TD]
[TD]10028[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]69[/TD]
[TD="align: right"]20986[/TD]
[TD="align: right"]5282803120[/TD]
[TD="align: right"]122105278[/TD]
[TD="align: right"]$1,874.40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]57[/TD]
[TD]10029[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,874.40[/TD]
[TD]H4111620[/TD]
[TD="align: right"]9.08655E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]58[/TD]
[TD]10029[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]71[/TD]
[TD="align: right"]17565[/TD]
[TD="align: right"]7.0103E+11[/TD]
[TD="align: right"]322172496[/TD]
[TD="align: right"]$776.42[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]59[/TD]
[TD]10030[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]72[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$776.42[/TD]
[TD]H4145383[/TD]
[TD="align: right"]9.64787E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]60[/TD]
[TD]10030[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]73[/TD]
[TD="align: right"]41513[/TD]
[TD="align: right"]739928872[/TD]
[TD="align: right"]122100024[/TD]
[TD="align: right"]$6,793.60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]61[/TD]
[TD]10031[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]74[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,793.60[/TD]
[TD]H4082058[/TD]
[TD="align: right"]8.15243E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]62[/TD]
[TD]10031[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD="align: right"]11647[/TD]
[TD="align: right"]6706568539[/TD]
[TD="align: right"]122105278[/TD]
[TD="align: right"]$7,823.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]63[/TD]
[TD]10032[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]76[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,823.00[/TD]
[TD]H4079864[/TD]
[TD="align: right"]8.0802E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]64[/TD]
[TD]10032[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]77[/TD]
[TD="align: right"]8156[/TD]
[TD="align: right"]2527036162[/TD]
[TD="align: right"]122105744[/TD]
[TD="align: right"]$6,543.06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]65[/TD]
[TD]10033[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]78[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,543.06[/TD]
[TD]H4077322[/TD]
[TD="align: right"]8.00747E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]66[/TD]
[TD]10033[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]79[/TD]
[TD="align: right"]4695[/TD]
[TD="align: right"]2296801331[/TD]
[TD="align: right"]122105278[/TD]
[TD="align: right"]$4,661.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]67[/TD]
[TD]10034[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,661.00[/TD]
[TD]H4103301[/TD]
[TD="align: right"]8.89121E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]68[/TD]
[TD]10034[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD="align: right"]8050[/TD]
[TD="align: right"]93466625[/TD]
[TD="align: right"]63100277[/TD]
[TD="align: right"]$3,781.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]69[/TD]
[TD]10035[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]82[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$3,781.00[/TD]
[TD]H4061057[/TD]
[TD="align: right"]1645161001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]70[/TD]
[TD]10035[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]83[/TD]
[TD="align: right"]1592[/TD]
[TD="align: right"]2.00004E+12[/TD]
[TD="align: right"]62000080[/TD]
[TD="align: right"]$1,206.77[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]71[/TD]
[TD]10036[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]84[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,206.77[/TD]
[TD]H3867060[/TD]
[TD="align: right"]9.13982E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]72[/TD]
[TD]10036[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]85[/TD]
[TD="align: right"]1593[/TD]
[TD="align: right"]2.00004E+12[/TD]
[TD="align: right"]62000080[/TD]
[TD="align: right"]$1,206.77[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]73[/TD]
[TD]10037[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]86[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,206.77[/TD]
[TD]H4054966[/TD]
[TD="align: right"]9.13982E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]74[/TD]
[TD]10037[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]87[/TD]
[TD="align: right"]4844[/TD]
[TD="align: right"]9062640848[/TD]
[TD="align: right"]67092022[/TD]
[TD="align: right"]$2,733.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]75[/TD]
[TD]10038[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]88[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,733.00[/TD]
[TD]H4066046[/TD]
[TD="align: right"]94236051001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]76[/TD]
[TD]10038[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]89[/TD]
[TD="align: right"]10931[/TD]
[TD="align: right"]3774324336[/TD]
[TD="align: right"]63100277[/TD]
[TD="align: right"]$1,535.31[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]77[/TD]
[TD]10039[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,535.31[/TD]
[TD]H4057456[/TD]
[TD="align: right"]194151001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]78[/TD]
[TD]10039[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]91[/TD]
[TD="align: right"]63697[/TD]
[TD="align: right"]17000030333[/TD]
[TD="align: right"]63102152[/TD]
[TD="align: right"]$1,062.41[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]79[/TD]
[TD]10040[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]92[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,062.41[/TD]
[TD]H4060462[/TD]
[TD="align: right"]1420131002[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]80[/TD]
[TD]10040[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]93[/TD]
[TD="align: right"]2247[/TD]
[TD="align: right"]558155110[/TD]
[TD="align: right"]267084131[/TD]
[TD="align: right"]$1,132.44[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]81[/TD]
[TD]10041[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]94[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,132.44[/TD]
[TD]H4059838[/TD]
[TD="align: right"]1198611001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]82[/TD]
[TD]10041[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]95[/TD]
[TD="align: right"]27862[/TD]
[TD="align: right"]252590440[/TD]
[TD="align: right"]122101706[/TD]
[TD="align: right"]$4,238.06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]83[/TD]
[TD]10042[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]96[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,238.06[/TD]
[TD]H3933255[/TD]
[TD="align: right"]9.23671E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]84[/TD]
[TD]10042[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]97[/TD]
[TD="align: right"]27737[/TD]
[TD="align: right"]9686590218[/TD]
[TD="align: right"]122105278[/TD]
[TD="align: right"]$13,509.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]85[/TD]
[TD]10043[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]98[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$13,509.00[/TD]
[TD]H4106720[/TD]
[TD="align: right"]9.00024E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]86[/TD]
[TD]10043[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]99[/TD]
[TD="align: right"]7707[/TD]
[TD="align: right"]2517289518[/TD]
[TD="align: right"]122105744[/TD]
[TD="align: right"]$922.98[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]87[/TD]
[TD]10044[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$922.98[/TD]
[TD]H4140118[/TD]
[TD="align: right"]9.54561E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]88[/TD]
[TD]10044[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD="align: right"]3248[/TD]
[TD="align: right"]904156718[/TD]
[TD="align: right"]122100024[/TD]
[TD="align: right"]$17.20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]89[/TD]
[TD]10045[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$17.20[/TD]
[TD]H4110327[/TD]
[TD="align: right"]9.06303E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]90[/TD]
[TD]10045[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD="align: right"]25351[/TD]
[TD="align: right"]1281588[/TD]
[TD="align: right"]122100024[/TD]
[TD="align: right"]$5,870.90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]91[/TD]
[TD]10046[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]104[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,870.90[/TD]
[TD]H4141023[/TD]
[TD="align: right"]9.56013E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]92[/TD]
[TD]10046[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]105[/TD]
[TD="align: right"]2612[/TD]
[TD="align: right"]79152198[/TD]
[TD="align: right"]63104668[/TD]
[TD="align: right"]$3,904.72[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]93[/TD]
[TD]10047[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]106[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$3,904.72[/TD]
[TD]H4097472[/TD]
[TD="align: right"]8.64709E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]94[/TD]
[TD]10047[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]107[/TD]
[TD="align: right"]34231[/TD]
[TD="align: right"]6855504191[/TD]
[TD="align: right"]31201328[/TD]
[TD="align: right"]$264.60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]95[/TD]
[TD]10048[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]108[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$264.60[/TD]
[TD]H4062632[/TD]
[TD="align: right"]2293531001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]96[/TD]
[TD]10048[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD="align: right"]10327[/TD]
[TD="align: right"]8022867437[/TD]
[TD="align: right"]31207607[/TD]
[TD="align: right"]$2,848.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]97[/TD]
[TD]10049[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]110[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,848.50[/TD]
[TD]H4112134[/TD]
[TD="align: right"]9.10087E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]98[/TD]
[TD]10049[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD] RUN DATE: 0[/TD]
[TD="align: right"]01/01/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]CompanyName-EBS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]PAGE[/TD]
[TD]3[/TD]
[TD]OX 4777[/TD]
[/TR]
[TR]
[TD]112[/TD]
[TD]DEPOSIT DATE[/TD]
[TD]: 01/01/17[/TD]
[TD][/TD]
[TD]L[/TD]
[TD]OCKBOX REPORT - B[/TD]
[TD]OX 5128[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]113[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]FRO[/TD]
[TD]M BankName, N.A.[/TD]
[TD="align: right"]21000089[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]114[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]115[/TD]
[TD]CHK NBR CH[/TD]
[TD]K ACCT NBR[/TD]
[TD]CHK ABA #[/TD]
[TD]CHECK AMT[/TD]
[TD]INVOICE AMT[/TD]
[TD]INVOICE[/TD]
[TD]# CUST #[/TD]
[TD]BATCH[/TD]
[TD]SEQ#[/TD]
[TD]SYS SEQ #[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]116[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]117[/TD]
[TD="align: right"]39229[/TD]
[TD="align: right"]1112522[/TD]
[TD="align: right"]231372691[/TD]
[TD="align: right"]$1,832.37[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]99[/TD]
[TD]10050[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]118[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,832.37[/TD]
[TD]H4070118[/TD]
[TD="align: right"]1.30061E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[TD]10050[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]119[/TD]
[TD="align: right"]23098[/TD]
[TD="align: right"]2291822163[/TD]
[TD="align: right"]63100277[/TD]
[TD="align: right"]$2,820.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]101[/TD]
[TD]10051[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]120[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,820.00[/TD]
[TD]H4066225[/TD]
[TD="align: right"]1.00374E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]102[/TD]
[TD]10051[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]121[/TD]
[TD="align: right"]6120[/TD]
[TD="align: right"]2.00004E+12[/TD]
[TD="align: right"]63107513[/TD]
[TD="align: right"]$1,266.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]103[/TD]
[TD]10052[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]122[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,266.00[/TD]
[TD]H4050331[/TD]
[TD="align: right"]85311041001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]104[/TD]
[TD]10052[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD="align: right"]11815[/TD]
[TD="align: right"]3024075[/TD]
[TD="align: right"]11202392[/TD]
[TD="align: right"]$2,131.12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]105[/TD]
[TD]10053[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]124[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,131.12[/TD]
[TD]H4096923[/TD]
[TD="align: right"]8.63001E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]106[/TD]
[TD]10053[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD="align: right"]9944[/TD]
[TD="align: right"]104413398[/TD]
[TD="align: right"]11200608[/TD]
[TD="align: right"]$1,227.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]107[/TD]
[TD]10054[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]126[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$1,227.00[/TD]
[TD]H4061239[/TD]
[TD="align: right"]1703251001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]108[/TD]
[TD]10054[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]127[/TD]
[TD="align: right"]9003[/TD]
[TD="align: right"]96192614[/TD]
[TD="align: right"]11200608[/TD]
[TD="align: right"]$9,770.19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]109[/TD]
[TD]10055[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]128[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$9,770.19[/TD]
[TD]H4107045[/TD]
[TD="align: right"]9.00602E+11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]110[/TD]
[TD]10055[/TD]
[TD]OX 5128[/TD]
[/TR]
[TR]
[TD]129[/TD]
[TD="align: right"]3527[/TD]
[TD="align: right"]9803634224[/TD]
[TD="align: right"]221172186[/TD]
[TD="align: right"]$3,223.44[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]111[/TD]
[TD]10056[/TD]
[TD]OX 5128[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1058"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
How about
Code:
Sub AddLockbox()

    With Range("K2:K" & Range("I" & Rows.Count).End(xlUp).Row)
        .FormulaR1C1 = "=if(r[-1]c[-2]=""PAGE"",rc[-5],if(rc[-2]=""PAGE"","""",r[-1]c))"
        .Value = .Value
    End With

End Sub
And this will delete the intermediate headers as well, if needed.
Code:
Sub AddLockbox()

    Dim Ar As Areas
    Dim Rng As Range

    With Range("K2:K" & Range("I" & Rows.Count).End(xlUp).Row)
        .FormulaR1C1 = "=if(r[-1]c[-2]=""PAGE"",rc[-5],if(rc[-2]=""PAGE"","""",r[-1]c))"
        .Value = .Value
        Set Ar = .SpecialCells(xlBlanks).Areas
    End With
    For Each Rng In Ar
        Rng.Resize(6).EntireRow.Delete
    Next Rng

End Sub
 
Last edited:
Upvote 0
Wow you made my day! I can't believe that small amount of code completed the task I wanted to see! Great job... Thank you so much!
 
Upvote 0
Glad to help & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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