Hey guys! I have a serious issue that is driving me insane. Here's the problem:
I have proprietary software that generates an excel spreadsheet every week with sales data. The columns of this spread sheet and some example data are listed below...
B18 C18 D18 E18 F18 G18 H18 I18 J18 K18 L18 M18 N18 O18 P18 Q18 R18 S18 T18 U18
<colgroup><col span="6" width="130"><col span="3" width="130"><col width="130"><col width="130"><col width="130"><col width="130"><col span="2" width="130"><col span="5" width="130"></colgroup><tbody>
[TD="class: xl63, width: 130"]STK #
[/TD]
[TD="class: xl63, width: 130"]Buyer Full[/TD]
[TD="class: xl63, width: 130"]Caller Name[/TD]
[TD="class: xl63, width: 130"]Car Description Short[/TD]
[TD="class: xl63, width: 130"]Mini Deal[/TD]
[TD="class: xl63, width: 130"]Doesn't count in 8[/TD]
[TD="class: xl64, width: 130"]Date Purchased[/TD]
[TD="class: xl64, width: 130"]Balance Paid Date[/TD]
[TD="class: xl64, width: 130"]Date Sold[/TD]
[TD="class: xl63, width: 130"]How Sold[/TD]
[TD="class: xl64, width: 130"]Title Received Date[/TD]
[TD="class: xl65, width: 130"] Price Purchased [/TD]
[TD="class: xl66, width: 130"] Total Haul Cost [/TD]
[TD="class: xl65, width: 130"] Parts Total Price [/TD]
[TD="class: xl65, width: 130"] Price Sold [/TD]
[TD="class: xl65, width: 130"] Gross Margin [/TD]
[TD="class: xl65, width: 130"] Gross Margin-Haul [/TD]
[TD="class: xl65, width: 130"] Gross Margin-Haul & Parts [/TD]
[TD="class: xl65, width: 130"] Gross Margin-Haul & Parts(600) [/TD]
[TD="class: xl65, width: 130"] Gross Margin-Haul & Parts(750) [/TD]
</tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="6" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="3" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="2" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="5" width="130"> </colgroup><tbody>
[TD="class: xl65, width: 130"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="6" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="3" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="2" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="5" width="130"> </colgroup><tbody>
[TD="class: xl65, width: 130"]G0657[/TD]
[TD="class: xl65, width: 130"]Bryan Miller[/TD]
[TD="class: xl65, width: 130"][/TD]
[TD="class: xl65, width: 130"]2010 Nissan Frontier, XE X-CAB[/TD]
[TD="class: xl65, width: 130"]no
[/TD]
[TD="class: xl65, width: 130"]no
[/TD]
[TD="class: xl66, width: 130, align: right"]4/6/2015[/TD]
[TD="class: xl66, width: 130, align: right"]4/6/2015[/TD]
[TD="class: xl66, width: 130, align: right"]4/8/2015[/TD]
[TD="class: xl65, width: 130"]Direct Wholesale[/TD]
[TD="class: xl66, width: 130, align: right"]4/9/2015[/TD]
[TD="class: xl67, width: 130"] $ 2,000.00 [/TD]
[TD="class: xl68, width: 130"] $ - [/TD]
[TD="class: xl67, width: 130"] $ - [/TD]
[TD="class: xl67, width: 130"] $ 4,500.00 [/TD]
[TD="class: xl67, width: 130"] $ 2,500.00 [/TD]
[TD="class: xl67, width: 130"] $ 2,500.00 [/TD]
[TD="class: xl67, width: 130"] $ 2,500.00 [/TD]
[TD="class: xl67, width: 130"] $ 1,900.00 [/TD]
[TD="class: xl67, width: 130"] $ 1,750.00 [/TD]
[TD="class: xl65"]G0675LR[/TD]
[TD="class: xl65"]Bryan Miller[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2004 Toyota Highlander, Limite[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl66, align: right"]4/9/2015[/TD]
[TD="class: xl65"]Direct Wholesale[/TD]
[TD="class: xl66, align: right"]4/15/2015[/TD]
[TD="class: xl67"] $ 3,400.00 [/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 5,900.00 [/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl67"] $ 1,900.00 [/TD]
[TD="class: xl67"] $ 1,750.00 [/TD]
[TD="class: xl65"]G0677LR[/TD]
[TD="class: xl65"]Bryan Miller[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2011 Toyota RAV4, Limited 4WD [/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl66, align: right"]4/9/2015[/TD]
[TD="class: xl65"]Direct Wholesale[/TD]
[TD="class: xl66, align: right"]4/15/2015[/TD]
[TD="class: xl67"] $ 11,100.00 [/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 12,700.00 [/TD]
[TD="class: xl67"] $ 1,600.00 [/TD]
[TD="class: xl67"] $ 1,600.00 [/TD]
[TD="class: xl67"] $ 1,600.00 [/TD]
[TD="class: xl67"] $ 1,000.00 [/TD]
[TD="class: xl67"] $ 850.00 [/TD]
[TD="class: xl65"]G0700LRX[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2004 Toyota Highlander, Limite[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]4/13/2015[/TD]
[TD="class: xl66, align: right"]4/13/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl65"]G0408NLR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2008 Lexus LS 460, w/NAV/LEATH[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/2/2015[/TD]
[TD="class: xl66, align: right"]3/6/2015[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl65"]OVE[/TD]
[TD="class: xl66, align: right"]3/12/2015[/TD]
[TD="class: xl67"] $ 17,000.00 [/TD]
[TD="class: xl68"] $ 581.90 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 18,200.00 [/TD]
[TD="class: xl67"] $ 1,200.00 [/TD]
[TD="class: xl67"] $ 618.10 [/TD]
[TD="class: xl67"] $ 618.10 [/TD]
[TD="class: xl67"] $ 18.10 [/TD]
[TD="class: xl67"] $ (131.90)[/TD]
[TD="class: xl65"]G0492NLRX[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2007 Mercedes-Benz GL-Class, G[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/16/2015[/TD]
[TD="class: xl66, align: right"]3/25/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66, align: right"]4/6/2015[/TD]
[TD="class: xl67"] $ 10,000.00 [/TD]
[TD="class: xl68"] $ 400.00 [/TD]
[TD="class: xl67"] $ 18.00 [/TD]
[TD="class: xl67"] $ 12,500.00 [/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl67"] $ 2,100.00 [/TD]
[TD="class: xl67"] $ 2,082.00 [/TD]
[TD="class: xl67"] $ 1,482.00 [/TD]
[TD="class: xl67"] $ 1,332.00 [/TD]
[TD="class: xl65"]G0445LR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2007 Toyota Camry, SE w/LEATHE[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/9/2015[/TD]
[TD="class: xl66, align: right"]3/9/2015[/TD]
[TD="class: xl66, align: right"]4/13/2015[/TD]
[TD="class: xl65"]Direct Wholesale[/TD]
[TD="class: xl66, align: right"]3/20/2015[/TD]
[TD="class: xl67"] $ 5,000.00 [/TD]
[TD="class: xl68"] $ 475.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 6,000.00 [/TD]
[TD="class: xl67"] $ 1,000.00 [/TD]
[TD="class: xl67"] $ 525.00 [/TD]
[TD="class: xl67"] $ 525.00 [/TD]
[TD="class: xl67"] $ (75.00)[/TD]
[TD="class: xl67"] $ (225.00)[/TD]
[TD="class: xl65"]G0476[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2006 Honda Ridgeline, RT 4WD, [/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/13/2015[/TD]
[TD="class: xl66, align: right"]3/25/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl67"] $ 4,000.00 [/TD]
[TD="class: xl68"] $ 550.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 5,600.00 [/TD]
[TD="class: xl67"] $ 1,600.00 [/TD]
[TD="class: xl67"] $ 1,050.00 [/TD]
[TD="class: xl67"] $ 1,050.00 [/TD]
[TD="class: xl67"] $ 450.00 [/TD]
[TD="class: xl67"] $ 300.00 [/TD]
[TD="class: xl65"]G0500[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Toyota Highlander, 4WD, W[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/17/2015[/TD]
[TD="class: xl66, align: right"]3/23/2015[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl65"]OVE[/TD]
[TD="class: xl66, align: right"]3/27/2015[/TD]
[TD="class: xl67"] $ 11,500.00 [/TD]
[TD="class: xl68"] $ 75.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 13,000.00 [/TD]
[TD="class: xl67"] $ 1,500.00 [/TD]
[TD="class: xl67"] $ 1,425.00 [/TD]
[TD="class: xl67"] $ 1,425.00 [/TD]
[TD="class: xl67"] $ 825.00 [/TD]
[TD="class: xl67"] $ 675.00 [/TD]
[TD="class: xl65"]G0524LR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2005 Honda Odyssey, EX-L w/LEA[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/19/2015[/TD]
[TD="class: xl66, align: right"]3/23/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"] $ 3,000.00 [/TD]
[TD="class: xl68"] $ 525.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 4,100.00 [/TD]
[TD="class: xl67"] $ 1,100.00 [/TD]
[TD="class: xl67"] $ 575.00 [/TD]
[TD="class: xl67"] $ 575.00 [/TD]
[TD="class: xl67"] $ (25.00)[/TD]
[TD="class: xl67"] $ (175.00)[/TD]
[TD="class: xl65"]G0525LR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Chevrolet Traverse, LT w/[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/19/2015[/TD]
[TD="class: xl66, align: right"]3/23/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]OVE[/TD]
[TD="class: xl66, align: right"]3/31/2015[/TD]
[TD="class: xl67"] $ 8,000.00 [/TD]
[TD="class: xl68"] $ 500.00 [/TD]
[TD="class: xl67"] $ 301.33 [/TD]
[TD="class: xl67"] $ 9,400.00 [/TD]
[TD="class: xl67"] $ 1,400.00 [/TD]
[TD="class: xl67"] $ 900.00 [/TD]
[TD="class: xl67"] $ 598.67 [/TD]
[TD="class: xl67"] $ (1.33)[/TD]
[TD="class: xl67"] $ (151.33)[/TD]
[TD="class: xl65"]G0563[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Toyota Camry, LE, Gray[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/24/2015[/TD]
[TD="class: xl66, align: right"]3/25/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]OVE[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl67"] $ 5,850.00 [/TD]
[TD="class: xl68"] $ 450.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 7,400.00 [/TD]
[TD="class: xl67"] $ 1,550.00 [/TD]
[TD="class: xl67"] $ 1,100.00 [/TD]
[TD="class: xl67"] $ 1,100.00 [/TD]
[TD="class: xl67"] $ 500.00 [/TD]
[TD="class: xl67"] $ 350.00 [/TD]
[TD="class: xl65"]G0591L[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2011 Toyota Tacoma, TRD Sport [/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/27/2015[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66, align: right"]4/6/2015[/TD]
[TD="class: xl67"] $ 12,900.00 [/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 16,200.00 [/TD]
[TD="class: xl67"] $ 3,300.00 [/TD]
[TD="class: xl67"] $ 3,300.00 [/TD]
[TD="class: xl67"] $ 3,300.00 [/TD]
[TD="class: xl67"] $ 2,700.00 [/TD]
[TD="class: xl67"] $ 2,550.00 [/TD]
[TD="class: xl65"]G0602[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Toyota Camry, LE, Silver[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]4/3/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Direct Wholesale[/TD]
[TD="class: xl66, align: right"]4/9/2015[/TD]
[TD="class: xl67"] $ 4,600.00 [/TD]
[TD="class: xl68"] $ 300.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 6,400.00 [/TD]
[TD="class: xl67"] $ 1,800.00 [/TD]
[TD="class: xl67"] $ 1,500.00 [/TD]
[TD="class: xl67"] $ 1,500.00 [/TD]
[TD="class: xl67"] $ 900.00 [/TD]
[TD="class: xl67"] $ 750.00 [/TD]
[TD="class: xl65"]G0597NLR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Lexus IS 250, SPORT AWD w[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]4/1/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl67"] $ 9,750.00 [/TD]
[TD="class: xl68"] $ 400.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 12,800.00 [/TD]
[TD="class: xl67"] $ 3,050.00 [/TD]
[TD="class: xl67"] $ 2,650.00 [/TD]
[TD="class: xl67"] $ 2,650.00 [/TD]
[TD="class: xl67"] $ 2,050.00 [/TD]
[TD="class: xl67"] $ 1,900.00 [/TD]
[TD="class: xl65"]G0608[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2011 Toyota Tundra, DOUBLE CAB[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"] $ 11,000.00 [/TD]
[TD="class: xl68"] $ 500.00 [/TD]
[TD="class: xl67"] $ 173.67 [/TD]
[TD="class: xl67"] $ 14,900.00 [/TD]
[TD="class: xl67"] $ 3,900.00 [/TD]
[TD="class: xl67"] $ 3,400.00 [/TD]
[TD="class: xl67"] $ 3,226.33 [/TD]
[TD="class: xl67"] $ 2,626.33 [/TD]
[TD="class: xl67"] $ 2,476.33 [/TD]
</tbody>
[/TD]
[TD="class: xl65, width: 130"][/TD]
[TD="class: xl66, width: 130, align: right"][/TD]
[TD="class: xl66, width: 130, align: right"][/TD]
[TD="class: xl66, width: 130, align: right"][/TD]
[TD="class: xl65, width: 130"][/TD]
[TD="class: xl66, width: 130, align: right"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl68, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
</tbody>
In order to calculate commissions based on the data from the first spreadsheet, I have another workbook that has tabs for each buyer. That spreadsheet looks like this...
B133 C133 D133 E133 F133 G133 H133 I133 J133 K133 L133 M133
<colgroup><col width="239"><col width="87"><col width="211"><col width="111"><col width="111"><col span="2" width="111"><col width="117"><col width="113"><col width="102"><col width="171"><col width="102"></colgroup><tbody>
[TD="class: xl63, width: 239"]Bryan Miller
[/TD]
[TD="class: xl63, width: 87"]Stock #[/TD]
[TD="class: xl63, width: 211"]Description[/TD]
[TD="class: xl64, width: 111"] Cost [/TD]
[TD="class: xl65, width: 111"] Haul [/TD]
[TD="class: xl64, width: 111"] Sale Fee [/TD]
[TD="class: xl64, width: 111"] Pac [/TD]
[TD="class: xl64, width: 117"] Repairs [/TD]
[TD="class: xl64, width: 113"] Sold $ [/TD]
[TD="class: xl64, width: 102"] Profit [/TD]
[TD="class: xl63, width: 171"]Draft (1=yes/0=no)[/TD]
[TD="class: xl63, width: 102"]Mini Deal[/TD]
</tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:8740;width:179pt" width="239"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:7716;width:158pt" width="211"> <col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:4059; width:83pt" span="2" width="111"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:6253;width:128pt" width="171"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> </colgroup><tbody>
[TD="class: xl65, width: 239"][/TD]
[TD="class: xl65, width: 87"][/TD]
[TD="class: xl65, width: 211"][/TD]
[TD="class: xl66, width: 111"][/TD]
[TD="class: xl68, width: 111"][/TD]
[TD="class: xl66, width: 111"] $ 200.00 [/TD]
[TD="class: xl66, width: 111"] $ 550.00 [/TD]
[TD="class: xl66, width: 117"][/TD]
[TD="class: xl66, width: 113"][/TD]
[TD="class: xl66, width: 102"] $ - [/TD]
[TD="class: xl65, width: 171"][/TD]
[TD="class: xl65, width: 102"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
</tbody>
Obviously these two spreadsheets are not formatted the same as far as columns go, and only certain data points need to be transferred over.
I want to a VBA function that will let me automatically populate the second spreadsheet with the click of a button (active x control or something).
I can't use VLOOKUP because the data changes every week (no unique values) and a single buyer can have up to 10 purchased vehicles. I can't use INDEX & MATCH because of the same reason... the spread sheet changes every week (the data, not the format).
So if "Bryan Miller" purchased 8 vehicles, I want all the vehicles that he purchased to transfer from the 1st spreadsheet to the 2nd.
Here's how the data needs to match up based on the columns and rows used as an example above (end result of the second spread sheet):
B133 C133 D133 E133 F133 G133 H133 I133 J133 K133 L133 M133
BLANK B18 E18 M18 N18 LEAVE LEAVE O18 P18 Q18 LEAVE F18
CAN ANYONE HELP ME?
I have proprietary software that generates an excel spreadsheet every week with sales data. The columns of this spread sheet and some example data are listed below...
B18 C18 D18 E18 F18 G18 H18 I18 J18 K18 L18 M18 N18 O18 P18 Q18 R18 S18 T18 U18
<colgroup><col span="6" width="130"><col span="3" width="130"><col width="130"><col width="130"><col width="130"><col width="130"><col span="2" width="130"><col span="5" width="130"></colgroup><tbody>
[TD="class: xl63, width: 130"]STK #
[/TD]
[TD="class: xl63, width: 130"]Buyer Full[/TD]
[TD="class: xl63, width: 130"]Caller Name[/TD]
[TD="class: xl63, width: 130"]Car Description Short[/TD]
[TD="class: xl63, width: 130"]Mini Deal[/TD]
[TD="class: xl63, width: 130"]Doesn't count in 8[/TD]
[TD="class: xl64, width: 130"]Date Purchased[/TD]
[TD="class: xl64, width: 130"]Balance Paid Date[/TD]
[TD="class: xl64, width: 130"]Date Sold[/TD]
[TD="class: xl63, width: 130"]How Sold[/TD]
[TD="class: xl64, width: 130"]Title Received Date[/TD]
[TD="class: xl65, width: 130"] Price Purchased [/TD]
[TD="class: xl66, width: 130"] Total Haul Cost [/TD]
[TD="class: xl65, width: 130"] Parts Total Price [/TD]
[TD="class: xl65, width: 130"] Price Sold [/TD]
[TD="class: xl65, width: 130"] Gross Margin [/TD]
[TD="class: xl65, width: 130"] Gross Margin-Haul [/TD]
[TD="class: xl65, width: 130"] Gross Margin-Haul & Parts [/TD]
[TD="class: xl65, width: 130"] Gross Margin-Haul & Parts(600) [/TD]
[TD="class: xl65, width: 130"] Gross Margin-Haul & Parts(750) [/TD]
</tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="6" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="3" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="2" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="5" width="130"> </colgroup><tbody>
[TD="class: xl65, width: 130"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="6" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="3" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="2" width="130"> <col style="mso-width-source:userset;mso-width-alt:4754; width:98pt" span="5" width="130"> </colgroup><tbody>
[TD="class: xl65, width: 130"]G0657[/TD]
[TD="class: xl65, width: 130"]Bryan Miller[/TD]
[TD="class: xl65, width: 130"][/TD]
[TD="class: xl65, width: 130"]2010 Nissan Frontier, XE X-CAB[/TD]
[TD="class: xl65, width: 130"]no
[/TD]
[TD="class: xl65, width: 130"]no
[/TD]
[TD="class: xl66, width: 130, align: right"]4/6/2015[/TD]
[TD="class: xl66, width: 130, align: right"]4/6/2015[/TD]
[TD="class: xl66, width: 130, align: right"]4/8/2015[/TD]
[TD="class: xl65, width: 130"]Direct Wholesale[/TD]
[TD="class: xl66, width: 130, align: right"]4/9/2015[/TD]
[TD="class: xl67, width: 130"] $ 2,000.00 [/TD]
[TD="class: xl68, width: 130"] $ - [/TD]
[TD="class: xl67, width: 130"] $ - [/TD]
[TD="class: xl67, width: 130"] $ 4,500.00 [/TD]
[TD="class: xl67, width: 130"] $ 2,500.00 [/TD]
[TD="class: xl67, width: 130"] $ 2,500.00 [/TD]
[TD="class: xl67, width: 130"] $ 2,500.00 [/TD]
[TD="class: xl67, width: 130"] $ 1,900.00 [/TD]
[TD="class: xl67, width: 130"] $ 1,750.00 [/TD]
[TD="class: xl65"]G0675LR[/TD]
[TD="class: xl65"]Bryan Miller[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2004 Toyota Highlander, Limite[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl66, align: right"]4/9/2015[/TD]
[TD="class: xl65"]Direct Wholesale[/TD]
[TD="class: xl66, align: right"]4/15/2015[/TD]
[TD="class: xl67"] $ 3,400.00 [/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 5,900.00 [/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl67"] $ 1,900.00 [/TD]
[TD="class: xl67"] $ 1,750.00 [/TD]
[TD="class: xl65"]G0677LR[/TD]
[TD="class: xl65"]Bryan Miller[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2011 Toyota RAV4, Limited 4WD [/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl66, align: right"]4/9/2015[/TD]
[TD="class: xl65"]Direct Wholesale[/TD]
[TD="class: xl66, align: right"]4/15/2015[/TD]
[TD="class: xl67"] $ 11,100.00 [/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 12,700.00 [/TD]
[TD="class: xl67"] $ 1,600.00 [/TD]
[TD="class: xl67"] $ 1,600.00 [/TD]
[TD="class: xl67"] $ 1,600.00 [/TD]
[TD="class: xl67"] $ 1,000.00 [/TD]
[TD="class: xl67"] $ 850.00 [/TD]
[TD="class: xl65"]G0700LRX[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2004 Toyota Highlander, Limite[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]4/13/2015[/TD]
[TD="class: xl66, align: right"]4/13/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl65"]G0408NLR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2008 Lexus LS 460, w/NAV/LEATH[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/2/2015[/TD]
[TD="class: xl66, align: right"]3/6/2015[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl65"]OVE[/TD]
[TD="class: xl66, align: right"]3/12/2015[/TD]
[TD="class: xl67"] $ 17,000.00 [/TD]
[TD="class: xl68"] $ 581.90 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 18,200.00 [/TD]
[TD="class: xl67"] $ 1,200.00 [/TD]
[TD="class: xl67"] $ 618.10 [/TD]
[TD="class: xl67"] $ 618.10 [/TD]
[TD="class: xl67"] $ 18.10 [/TD]
[TD="class: xl67"] $ (131.90)[/TD]
[TD="class: xl65"]G0492NLRX[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2007 Mercedes-Benz GL-Class, G[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/16/2015[/TD]
[TD="class: xl66, align: right"]3/25/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66, align: right"]4/6/2015[/TD]
[TD="class: xl67"] $ 10,000.00 [/TD]
[TD="class: xl68"] $ 400.00 [/TD]
[TD="class: xl67"] $ 18.00 [/TD]
[TD="class: xl67"] $ 12,500.00 [/TD]
[TD="class: xl67"] $ 2,500.00 [/TD]
[TD="class: xl67"] $ 2,100.00 [/TD]
[TD="class: xl67"] $ 2,082.00 [/TD]
[TD="class: xl67"] $ 1,482.00 [/TD]
[TD="class: xl67"] $ 1,332.00 [/TD]
[TD="class: xl65"]G0445LR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2007 Toyota Camry, SE w/LEATHE[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/9/2015[/TD]
[TD="class: xl66, align: right"]3/9/2015[/TD]
[TD="class: xl66, align: right"]4/13/2015[/TD]
[TD="class: xl65"]Direct Wholesale[/TD]
[TD="class: xl66, align: right"]3/20/2015[/TD]
[TD="class: xl67"] $ 5,000.00 [/TD]
[TD="class: xl68"] $ 475.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 6,000.00 [/TD]
[TD="class: xl67"] $ 1,000.00 [/TD]
[TD="class: xl67"] $ 525.00 [/TD]
[TD="class: xl67"] $ 525.00 [/TD]
[TD="class: xl67"] $ (75.00)[/TD]
[TD="class: xl67"] $ (225.00)[/TD]
[TD="class: xl65"]G0476[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2006 Honda Ridgeline, RT 4WD, [/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/13/2015[/TD]
[TD="class: xl66, align: right"]3/25/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl67"] $ 4,000.00 [/TD]
[TD="class: xl68"] $ 550.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 5,600.00 [/TD]
[TD="class: xl67"] $ 1,600.00 [/TD]
[TD="class: xl67"] $ 1,050.00 [/TD]
[TD="class: xl67"] $ 1,050.00 [/TD]
[TD="class: xl67"] $ 450.00 [/TD]
[TD="class: xl67"] $ 300.00 [/TD]
[TD="class: xl65"]G0500[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Toyota Highlander, 4WD, W[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/17/2015[/TD]
[TD="class: xl66, align: right"]3/23/2015[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl65"]OVE[/TD]
[TD="class: xl66, align: right"]3/27/2015[/TD]
[TD="class: xl67"] $ 11,500.00 [/TD]
[TD="class: xl68"] $ 75.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 13,000.00 [/TD]
[TD="class: xl67"] $ 1,500.00 [/TD]
[TD="class: xl67"] $ 1,425.00 [/TD]
[TD="class: xl67"] $ 1,425.00 [/TD]
[TD="class: xl67"] $ 825.00 [/TD]
[TD="class: xl67"] $ 675.00 [/TD]
[TD="class: xl65"]G0524LR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2005 Honda Odyssey, EX-L w/LEA[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/19/2015[/TD]
[TD="class: xl66, align: right"]3/23/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"] $ 3,000.00 [/TD]
[TD="class: xl68"] $ 525.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 4,100.00 [/TD]
[TD="class: xl67"] $ 1,100.00 [/TD]
[TD="class: xl67"] $ 575.00 [/TD]
[TD="class: xl67"] $ 575.00 [/TD]
[TD="class: xl67"] $ (25.00)[/TD]
[TD="class: xl67"] $ (175.00)[/TD]
[TD="class: xl65"]G0525LR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Chevrolet Traverse, LT w/[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/19/2015[/TD]
[TD="class: xl66, align: right"]3/23/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]OVE[/TD]
[TD="class: xl66, align: right"]3/31/2015[/TD]
[TD="class: xl67"] $ 8,000.00 [/TD]
[TD="class: xl68"] $ 500.00 [/TD]
[TD="class: xl67"] $ 301.33 [/TD]
[TD="class: xl67"] $ 9,400.00 [/TD]
[TD="class: xl67"] $ 1,400.00 [/TD]
[TD="class: xl67"] $ 900.00 [/TD]
[TD="class: xl67"] $ 598.67 [/TD]
[TD="class: xl67"] $ (1.33)[/TD]
[TD="class: xl67"] $ (151.33)[/TD]
[TD="class: xl65"]G0563[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Toyota Camry, LE, Gray[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/24/2015[/TD]
[TD="class: xl66, align: right"]3/25/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]OVE[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl67"] $ 5,850.00 [/TD]
[TD="class: xl68"] $ 450.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 7,400.00 [/TD]
[TD="class: xl67"] $ 1,550.00 [/TD]
[TD="class: xl67"] $ 1,100.00 [/TD]
[TD="class: xl67"] $ 1,100.00 [/TD]
[TD="class: xl67"] $ 500.00 [/TD]
[TD="class: xl67"] $ 350.00 [/TD]
[TD="class: xl65"]G0591L[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2011 Toyota Tacoma, TRD Sport [/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/27/2015[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66, align: right"]4/6/2015[/TD]
[TD="class: xl67"] $ 12,900.00 [/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 16,200.00 [/TD]
[TD="class: xl67"] $ 3,300.00 [/TD]
[TD="class: xl67"] $ 3,300.00 [/TD]
[TD="class: xl67"] $ 3,300.00 [/TD]
[TD="class: xl67"] $ 2,700.00 [/TD]
[TD="class: xl67"] $ 2,550.00 [/TD]
[TD="class: xl65"]G0602[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Toyota Camry, LE, Silver[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]4/3/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Direct Wholesale[/TD]
[TD="class: xl66, align: right"]4/9/2015[/TD]
[TD="class: xl67"] $ 4,600.00 [/TD]
[TD="class: xl68"] $ 300.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 6,400.00 [/TD]
[TD="class: xl67"] $ 1,800.00 [/TD]
[TD="class: xl67"] $ 1,500.00 [/TD]
[TD="class: xl67"] $ 1,500.00 [/TD]
[TD="class: xl67"] $ 900.00 [/TD]
[TD="class: xl67"] $ 750.00 [/TD]
[TD="class: xl65"]G0597NLR[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2010 Lexus IS 250, SPORT AWD w[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]4/1/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66, align: right"]4/8/2015[/TD]
[TD="class: xl67"] $ 9,750.00 [/TD]
[TD="class: xl68"] $ 400.00 [/TD]
[TD="class: xl67"] $ - [/TD]
[TD="class: xl67"] $ 12,800.00 [/TD]
[TD="class: xl67"] $ 3,050.00 [/TD]
[TD="class: xl67"] $ 2,650.00 [/TD]
[TD="class: xl67"] $ 2,650.00 [/TD]
[TD="class: xl67"] $ 2,050.00 [/TD]
[TD="class: xl67"] $ 1,900.00 [/TD]
[TD="class: xl65"]G0608[/TD]
[TD="class: xl65"]Chad Dickerson[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]2011 Toyota Tundra, DOUBLE CAB[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl65"]no[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]3/30/2015[/TD]
[TD="class: xl66, align: right"]4/14/2015[/TD]
[TD="class: xl65"]Imperial Auction[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"] $ 11,000.00 [/TD]
[TD="class: xl68"] $ 500.00 [/TD]
[TD="class: xl67"] $ 173.67 [/TD]
[TD="class: xl67"] $ 14,900.00 [/TD]
[TD="class: xl67"] $ 3,900.00 [/TD]
[TD="class: xl67"] $ 3,400.00 [/TD]
[TD="class: xl67"] $ 3,226.33 [/TD]
[TD="class: xl67"] $ 2,626.33 [/TD]
[TD="class: xl67"] $ 2,476.33 [/TD]
</tbody>
[TD="class: xl65, width: 130"][/TD]
[TD="class: xl66, width: 130, align: right"][/TD]
[TD="class: xl66, width: 130, align: right"][/TD]
[TD="class: xl66, width: 130, align: right"][/TD]
[TD="class: xl65, width: 130"][/TD]
[TD="class: xl66, width: 130, align: right"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl68, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl67, width: 130"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
</tbody>
In order to calculate commissions based on the data from the first spreadsheet, I have another workbook that has tabs for each buyer. That spreadsheet looks like this...
B133 C133 D133 E133 F133 G133 H133 I133 J133 K133 L133 M133
<colgroup><col width="239"><col width="87"><col width="211"><col width="111"><col width="111"><col span="2" width="111"><col width="117"><col width="113"><col width="102"><col width="171"><col width="102"></colgroup><tbody>
[TD="class: xl63, width: 239"]Bryan Miller
[/TD]
[TD="class: xl63, width: 87"]Stock #[/TD]
[TD="class: xl63, width: 211"]Description[/TD]
[TD="class: xl64, width: 111"] Cost [/TD]
[TD="class: xl65, width: 111"] Haul [/TD]
[TD="class: xl64, width: 111"] Sale Fee [/TD]
[TD="class: xl64, width: 111"] Pac [/TD]
[TD="class: xl64, width: 117"] Repairs [/TD]
[TD="class: xl64, width: 113"] Sold $ [/TD]
[TD="class: xl64, width: 102"] Profit [/TD]
[TD="class: xl63, width: 171"]Draft (1=yes/0=no)[/TD]
[TD="class: xl63, width: 102"]Mini Deal[/TD]
</tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:8740;width:179pt" width="239"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:7716;width:158pt" width="211"> <col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:4059; width:83pt" span="2" width="111"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:6253;width:128pt" width="171"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> </colgroup><tbody>
[TD="class: xl65, width: 239"][/TD]
[TD="class: xl65, width: 87"][/TD]
[TD="class: xl65, width: 211"][/TD]
[TD="class: xl66, width: 111"][/TD]
[TD="class: xl68, width: 111"][/TD]
[TD="class: xl66, width: 111"] $ 200.00 [/TD]
[TD="class: xl66, width: 111"] $ 550.00 [/TD]
[TD="class: xl66, width: 117"][/TD]
[TD="class: xl66, width: 113"][/TD]
[TD="class: xl66, width: 102"] $ - [/TD]
[TD="class: xl65, width: 171"][/TD]
[TD="class: xl65, width: 102"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"] $ 200.00 [/TD]
[TD="class: xl66"] $ 550.00 [/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
</tbody>
Obviously these two spreadsheets are not formatted the same as far as columns go, and only certain data points need to be transferred over.
I want to a VBA function that will let me automatically populate the second spreadsheet with the click of a button (active x control or something).
I can't use VLOOKUP because the data changes every week (no unique values) and a single buyer can have up to 10 purchased vehicles. I can't use INDEX & MATCH because of the same reason... the spread sheet changes every week (the data, not the format).
So if "Bryan Miller" purchased 8 vehicles, I want all the vehicles that he purchased to transfer from the 1st spreadsheet to the 2nd.
Here's how the data needs to match up based on the columns and rows used as an example above (end result of the second spread sheet):
B133 C133 D133 E133 F133 G133 H133 I133 J133 K133 L133 M133
BLANK B18 E18 M18 N18 LEAVE LEAVE O18 P18 Q18 LEAVE F18
CAN ANYONE HELP ME?