Spreadsheet: 106828d1304002670-excel-2007-automatically-load-chart-title-in-front-of-list-example
Sheet: act_submissionsByMediaType2 (2)

 |  |  | Zone
 |  |  | Medium | Count | % of Count | Ad Cost | % of Cost | Amt Paid | % of Paid | Ad Cost of Multicultural | % Multicultural
 |  |  | Show/Mall Display | 22 | 0.01 | 45605 | 0 | 31433.5 | 0.01 | 0 | 0
 | Zone |  | Direct Mail/Circular | 76 | 0.02 | 776452.02 | 0.08 | 496367.5 | 0.08 | 0 | 0
 | Zone |  | Events | 52 | 0.02 | 212378.29 | 0.02 | 143112.25 | 0.02 | 0 | 0
 | Zone |  | ILM | 532 | 0.16 | 468120.75 | 0.05 | 317174.91 | 0.05 | 0 | 0
 | Zone |  | Internet Ad | 62 | 0.02 | 191423.97 | 0.02 | 125472.64 | 0.02 | 0 | 0
 | Zone |  | Internet-misc(leads and optimization) | 145 | 0.04 | 319128.77 | 0.03 | 192897.81 | 0.03 | 0 | 0
 | Zone |  | Magazine Ad | 27 | 0.01 | 60658.5 | 0.01 | 36173.5 | 0.01 | 0 | 0
 | Zone |  | Newspaper Ad | 621 | 0.18 | 2147630.14 | 0.23 | 1433542.97 | 0.23 | 0 | 0
 | Zone |  | Radio Script | 762 | 0.22 | 1398832.45 | 0.15 | 858474.76 | 0.14 | 0 | 0
 | Zone |  | Search Engine Marketing | 19 | 0.01 | 36794.46 | 0 | 24824.38 | 0 | 0 | 0
 | Zone |  | Service | 8 | 0 | 5592.9 | 0 | 1149.14 | 0 | 0 | 0
 | Zone |  | Sponsorship | 6 | 0 | 48415 | 0.01 | 33890.5 | 0.01 | 0 | 0
 | Zone |  | Transit/Outdoor Board | 115 | 0.03 | 210261.8 | 0.02 | 110727.27 | 0.02 | 0 | 0
 | Zone |  | TV Storyboard | 934 | 0.28 | 3481261.23 | 0.37 | 2299764.36 | 0.38 | 0 | 0
 | Zone |  | Yellow Pages Ad | 9 | 0 | 4722.72 | 0 | 3218.39 | 0 | 0 | 0
 | Zone
 | Zone
 | Zone |  | TOTAL: | 3390 | 1 | 9407278 | 1 | 6108223.88 | 1 | 0 | 0
I want to enter a formula in B26 that I can pull down the entire spreadsheet that pulls the dealer # out of column B (you supplied that) |  |  | Dealer (030197)
Using the formula in B26, I want cells B27-35 to say "030197" |  |  | Medium | Count | % of Count | Ad Cost | % of Cost | Amt Paid | % of Paid | Ad Cost of Multicultural | % Multicultural
 |  |  | ILM | 12 | 0.2 | 7139.5 | 0.06 | 4997.65 | 0.06 | 0 | 0
 |  |  | Newspaper Ad | 28 | 0.46 | 82282.67 | 0.7 | 57131.98 | 0.7 | 0 | 0
 |  |  | Radio Script | 2 | 0.03 | 2157.5 | 0.02 | 1833.96 | 0.02 | 0 | 0
 |  |  | Transit/Outdoor Board | 19 | 0.31 | 25560 | 0.22 | 17892 | 0.22 | 0 | 0
 |  |  | TOTAL: | 61 | 1 | 117139.67 | 1 | 81855.59 | 1 | 0 | 0
I want the formula from B26 to automatically know that I want it to say 030290 in B36 |  |  | Dealer (030290)
I want the formula to make cells B37-45 say "030290" |  |  | Medium | Count | % of Count | Ad Cost | % of Cost | Amt Paid | % of Paid | Ad Cost of Multicultural | % Multicultural
 |  |  | ILM | 12 | 0.06 | 6737 | 0.05 | 4715.9 | 0.07 | 0 | 0
 |  |  | Newspaper Ad | 63 | 0.3 | 39760.77 | 0.27 | 14800.08 | 0.22 | 0 | 0
 |  |  | Radio Script | 31 | 0.15 | 16693.07 | 0.11 | 8443.91 | 0.13 | 0 | 0
 |  |  | TV Storyboard | 105 | 0.5 | 86114.83 | 0.58 | 38330.32 | 0.58 | 0 | 0
 |  |  | TOTAL: | 211 | 1 | 149305.67 | 1 | 66290.21 | 1 | 0 | 0
I want the formula from B26 to automatically know that I want it to say 040581 in B46 |  |  | Dealer (040581)
I want the formula to make cells B47-52 say "040581" |  |  | Medium | Count | % of Count | Ad Cost | % of Cost | Amt Paid | % of Paid | Ad Cost of Multicultural | % Multicultural
 |  |  | ILM | 12 | 0.33 | 5136.25 | 0.1 | 3299.64 | 0.24 | 0 | 0
 |  |  | Transit/Outdoor Board | 24 | 0.67 | 44550 | 0.9 | 10640 | 0.76 | 0 | 0
 |  |  | TOTAL: | 36 | 1 | 49686.25 | 1 | 13939.64 | 1 | 0 | 0