Hi -
Thank you in advance for help on this!
I am trying to create a macro (or maybe multiple?) that looks at a a few fields in a "Raw Data" tab and exports results into a tab called "Opportunities". I have 4 categories listed in a column ("Lifestyle", "Multi", "Tech", "Auto" ). I am trying to create 4 separate buttons in the Opportunities tab for each that follow the following rules:
Data to output into Opportunities
[TABLE="width: 445"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Opportunity Name[/TD]
[TD]Opportunity Owner[/TD]
[TD]New[/TD]
[TD]Renewal[/TD]
[TD]Carryover[/TD]
[/TR]
[TR]
[TD]Opportunity 123[/TD]
[TD]Bob Smith[/TD]
[TD][/TD]
[TD]$109,223[/TD]
[TD]$40,774[/TD]
[/TR]
[TR]
[TD]Opportunity 128[/TD]
[TD]Bob Smith[/TD]
[TD]$31,060[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
- Things to keep in mind:
[TABLE="width: 2107"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Opportunity Owner[/TD]
[TD]Account Name[/TD]
[TD]Opportunity Name[/TD]
[TD]Client Category[/TD]
[TD]2018 Digital Region[/TD]
[TD] 2018 Region[/TD]
[TD]Venue[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Days at Prob[/TD]
[TD]Probability (%)[/TD]
[TD]Product Name[/TD]
[TD]R Type[/TD]
[TD]S Inventory[/TD]
[TD]S Prod[/TD]
[TD]Expen S[/TD]
[TD]CM PROD[/TD]
[TD]Days Bucket[/TD]
[TD]Sales POD[/TD]
[TD]S or D[/TD]
[TD]Account POD[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 123[/TD]
[TD]Opportunity 123[/TD]
[TD]Food[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 123[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]55[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$111,501[/TD]
[TD]$45,068[/TD]
[TD]$109,223[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 123b[/TD]
[TD]Opportunity 123[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 124[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]249[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$3,149[/TD]
[TD]$2,146[/TD]
[TD]$40,774[/TD]
[TD]40+[/TD]
[TD]Enterprise[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 125[/TD]
[TD]Opportunity 125[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 125[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$36,876[/TD]
[TD]$92,037[/TD]
[TD]$45,768[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 126[/TD]
[TD]Opportunity 126[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 126[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]217[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$36,338[/TD]
[TD]$44,417[/TD]
[TD]$121,225[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 127[/TD]
[TD]Opportunity 127[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 127[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$99,261[/TD]
[TD]$83,738[/TD]
[TD]$21,815[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 128[/TD]
[TD]Opportunity 128[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 128[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]61[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]New[/TD]
[TD]XXX[/TD]
[TD]$112,986[/TD]
[TD]$5,710[/TD]
[TD]$31,060[/TD]
[TD]40+[/TD]
[TD]Tech[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 129[/TD]
[TD]Opportunity 129[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 129[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$33,692[/TD]
[TD]$97,260[/TD]
[TD]$52,841[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 130[/TD]
[TD]Opportunity 130[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 130[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$103,634[/TD]
[TD]$29,028[/TD]
[TD]$58,450[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 131[/TD]
[TD]Opportunity 131[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 131[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$114,605[/TD]
[TD]$81,118[/TD]
[TD]$88,640[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 132[/TD]
[TD]Opportunity 132[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 132[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$93,009[/TD]
[TD]$103,432[/TD]
[TD]$77,888[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 133[/TD]
[TD]Opportunity 133[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 133[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$101,425[/TD]
[TD]$95,077[/TD]
[TD]$56,486[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 134[/TD]
[TD]Opportunity 134[/TD]
[TD]Telecommunications[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 134[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]330[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$124,886[/TD]
[TD]$6,294[/TD]
[TD]$60,924[/TD]
[TD]40+[/TD]
[TD]C&T[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 135[/TD]
[TD]Opportunity 135[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 135[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$107,249[/TD]
[TD]$120,698[/TD]
[TD]$26,576[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 136[/TD]
[TD]Opportunity 136[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 136[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$43,519[/TD]
[TD]$111,415[/TD]
[TD]$855[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 137[/TD]
[TD]Opportunity 137[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 137[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$21,369[/TD]
[TD]$73,453[/TD]
[TD]$64,164[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 138[/TD]
[TD]Opportunity 138[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 138[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$7,859[/TD]
[TD]$83,157[/TD]
[TD]$57,123[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 139[/TD]
[TD]Opportunity 139[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 139[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$17,357[/TD]
[TD]$101,002[/TD]
[TD]$82,221[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 140[/TD]
[TD]Opportunity 140[/TD]
[TD]Food[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 140[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]55[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$12,492[/TD]
[TD]$96,449[/TD]
[TD]$26,979[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 141[/TD]
[TD]Opportunity 141[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 141[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]249[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$10,112[/TD]
[TD]$76,557[/TD]
[TD]$92,298[/TD]
[TD]40+[/TD]
[TD]Enterprise[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 142[/TD]
[TD]Opportunity 142[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 142[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$62,251[/TD]
[TD]$111,068[/TD]
[TD]$24,511[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 143[/TD]
[TD]Opportunity 143[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 143[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$54,520[/TD]
[TD]$102,905[/TD]
[TD]$31,973[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 144[/TD]
[TD]Opportunity 144[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 144[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$86,803[/TD]
[TD]$8,869[/TD]
[TD]$118,660[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 145[/TD]
[TD]Opportunity 145[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 145[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]61[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]New[/TD]
[TD]XXX[/TD]
[TD]$118,992[/TD]
[TD]$4,577[/TD]
[TD]$53,738[/TD]
[TD]40+[/TD]
[TD]Tech[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 146[/TD]
[TD]Opportunity 146[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 146[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$58,141[/TD]
[TD]$75,398[/TD]
[TD]$70,245[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 147[/TD]
[TD]Opportunity 147[/TD]
[TD]Automotive[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 147[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]81[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$18,589[/TD]
[TD]$66,556[/TD]
[TD]$69,673[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Auto[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 148[/TD]
[TD]Opportunity 148[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 148[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$119,560[/TD]
[TD]$27,868[/TD]
[TD]$8,312[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 149[/TD]
[TD]Opportunity 149[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 149[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$50,713[/TD]
[TD]$78,221[/TD]
[TD]$11,109[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 150[/TD]
[TD]Opportunity 150[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 150[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$89,270[/TD]
[TD]$33,972[/TD]
[TD]$108,332[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 151[/TD]
[TD]Opportunity 151[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 151[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$51,667[/TD]
[TD]$55,737[/TD]
[TD]$70,271[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 152[/TD]
[TD]Opportunity 152[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 152[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$26,202[/TD]
[TD]$79,538[/TD]
[TD]$120,738[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 153[/TD]
[TD]Opportunity 153[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 153[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$99,693[/TD]
[TD]$56,440[/TD]
[TD]$40,579[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 154[/TD]
[TD]Opportunity 154[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 154[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$17,758[/TD]
[TD]$37,946[/TD]
[TD]$43,107[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance for help on this!
I am trying to create a macro (or maybe multiple?) that looks at a a few fields in a "Raw Data" tab and exports results into a tab called "Opportunities". I have 4 categories listed in a column ("Lifestyle", "Multi", "Tech", "Auto" ). I am trying to create 4 separate buttons in the Opportunities tab for each that follow the following rules:
- If Sales POD (Column S) = "Lifestyle", "Multi", "Tech", "Auto"
- If Probability (%) (Column K) >=75
- Then output the results in the "Opportunities" tab (cant figure out how to post a screen shot but I'd want it to look like the below)
- Then autosize columns
- Then format columns C-E to be currency
Data to output into Opportunities
[TABLE="width: 445"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Opportunity Name[/TD]
[TD]Opportunity Owner[/TD]
[TD]New[/TD]
[TD]Renewal[/TD]
[TD]Carryover[/TD]
[/TR]
[TR]
[TD]Opportunity 123[/TD]
[TD]Bob Smith[/TD]
[TD][/TD]
[TD]$109,223[/TD]
[TD]$40,774[/TD]
[/TR]
[TR]
[TD]Opportunity 128[/TD]
[TD]Bob Smith[/TD]
[TD]$31,060[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
- Things to keep in mind:
- I want the "Opportunities" tab to clear / refresh every time to allow for new data to be put in
- I don't want to output all of the columns in the Raw Data tab in the Opportunities tab. Only the few listed above
- I want to pull data based on if I pick "Lifestyle", "Multi", "Tech" or "Auto" (why I am thinking multiple buttons?)
- Column M (R Type) has "New", "Renewal" and "Carryover" relate to "CM Prod" (Column Q)
- So - in the Opportunities output the $ amount in column Q should be appropriately distributed based on the Opportunity Name (Column C)
- EX - There could be an Opportunity with the same name (see first two rows) but has $ amount in two different categories (in this example there is $ in Renewal and Carryover)
[TABLE="width: 2107"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Opportunity Owner[/TD]
[TD]Account Name[/TD]
[TD]Opportunity Name[/TD]
[TD]Client Category[/TD]
[TD]2018 Digital Region[/TD]
[TD] 2018 Region[/TD]
[TD]Venue[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Days at Prob[/TD]
[TD]Probability (%)[/TD]
[TD]Product Name[/TD]
[TD]R Type[/TD]
[TD]S Inventory[/TD]
[TD]S Prod[/TD]
[TD]Expen S[/TD]
[TD]CM PROD[/TD]
[TD]Days Bucket[/TD]
[TD]Sales POD[/TD]
[TD]S or D[/TD]
[TD]Account POD[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 123[/TD]
[TD]Opportunity 123[/TD]
[TD]Food[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 123[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]55[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$111,501[/TD]
[TD]$45,068[/TD]
[TD]$109,223[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 123b[/TD]
[TD]Opportunity 123[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 124[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]249[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$3,149[/TD]
[TD]$2,146[/TD]
[TD]$40,774[/TD]
[TD]40+[/TD]
[TD]Enterprise[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 125[/TD]
[TD]Opportunity 125[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 125[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$36,876[/TD]
[TD]$92,037[/TD]
[TD]$45,768[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 126[/TD]
[TD]Opportunity 126[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 126[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]217[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$36,338[/TD]
[TD]$44,417[/TD]
[TD]$121,225[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 127[/TD]
[TD]Opportunity 127[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 127[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$99,261[/TD]
[TD]$83,738[/TD]
[TD]$21,815[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 128[/TD]
[TD]Opportunity 128[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 128[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]61[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]New[/TD]
[TD]XXX[/TD]
[TD]$112,986[/TD]
[TD]$5,710[/TD]
[TD]$31,060[/TD]
[TD]40+[/TD]
[TD]Tech[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 129[/TD]
[TD]Opportunity 129[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 129[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$33,692[/TD]
[TD]$97,260[/TD]
[TD]$52,841[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 130[/TD]
[TD]Opportunity 130[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 130[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$103,634[/TD]
[TD]$29,028[/TD]
[TD]$58,450[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 131[/TD]
[TD]Opportunity 131[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 131[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$114,605[/TD]
[TD]$81,118[/TD]
[TD]$88,640[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 132[/TD]
[TD]Opportunity 132[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 132[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$93,009[/TD]
[TD]$103,432[/TD]
[TD]$77,888[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 133[/TD]
[TD]Opportunity 133[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 133[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$101,425[/TD]
[TD]$95,077[/TD]
[TD]$56,486[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 134[/TD]
[TD]Opportunity 134[/TD]
[TD]Telecommunications[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 134[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]330[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$124,886[/TD]
[TD]$6,294[/TD]
[TD]$60,924[/TD]
[TD]40+[/TD]
[TD]C&T[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 135[/TD]
[TD]Opportunity 135[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 135[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$107,249[/TD]
[TD]$120,698[/TD]
[TD]$26,576[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 136[/TD]
[TD]Opportunity 136[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 136[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$43,519[/TD]
[TD]$111,415[/TD]
[TD]$855[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 137[/TD]
[TD]Opportunity 137[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 137[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$21,369[/TD]
[TD]$73,453[/TD]
[TD]$64,164[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 138[/TD]
[TD]Opportunity 138[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 138[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$7,859[/TD]
[TD]$83,157[/TD]
[TD]$57,123[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 139[/TD]
[TD]Opportunity 139[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 139[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$17,357[/TD]
[TD]$101,002[/TD]
[TD]$82,221[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 140[/TD]
[TD]Opportunity 140[/TD]
[TD]Food[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 140[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]55[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$12,492[/TD]
[TD]$96,449[/TD]
[TD]$26,979[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 141[/TD]
[TD]Opportunity 141[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 141[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]249[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$10,112[/TD]
[TD]$76,557[/TD]
[TD]$92,298[/TD]
[TD]40+[/TD]
[TD]Enterprise[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 142[/TD]
[TD]Opportunity 142[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 142[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$62,251[/TD]
[TD]$111,068[/TD]
[TD]$24,511[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 143[/TD]
[TD]Opportunity 143[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 143[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$54,520[/TD]
[TD]$102,905[/TD]
[TD]$31,973[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 144[/TD]
[TD]Opportunity 144[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 144[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$86,803[/TD]
[TD]$8,869[/TD]
[TD]$118,660[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 145[/TD]
[TD]Opportunity 145[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 145[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]61[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]New[/TD]
[TD]XXX[/TD]
[TD]$118,992[/TD]
[TD]$4,577[/TD]
[TD]$53,738[/TD]
[TD]40+[/TD]
[TD]Tech[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 146[/TD]
[TD]Opportunity 146[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 146[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$58,141[/TD]
[TD]$75,398[/TD]
[TD]$70,245[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 147[/TD]
[TD]Opportunity 147[/TD]
[TD]Automotive[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 147[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]81[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$18,589[/TD]
[TD]$66,556[/TD]
[TD]$69,673[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Auto[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 148[/TD]
[TD]Opportunity 148[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 148[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$119,560[/TD]
[TD]$27,868[/TD]
[TD]$8,312[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 149[/TD]
[TD]Opportunity 149[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 149[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$50,713[/TD]
[TD]$78,221[/TD]
[TD]$11,109[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 150[/TD]
[TD]Opportunity 150[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 150[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$89,270[/TD]
[TD]$33,972[/TD]
[TD]$108,332[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 151[/TD]
[TD]Opportunity 151[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 151[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$51,667[/TD]
[TD]$55,737[/TD]
[TD]$70,271[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 152[/TD]
[TD]Opportunity 152[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 152[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$26,202[/TD]
[TD]$79,538[/TD]
[TD]$120,738[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 153[/TD]
[TD]Opportunity 153[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 153[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$99,693[/TD]
[TD]$56,440[/TD]
[TD]$40,579[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 154[/TD]
[TD]Opportunity 154[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 154[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$17,758[/TD]
[TD]$37,946[/TD]
[TD]$43,107[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
</tbody>[/TABLE]