row and column from one dropbox

X

xoptimizedrsx

New Member
Joined
Jan 4, 2010
Messages
22
I made my drop box list. next I made a sheet with all the values for each item.
note: this list is a group of 16 cells in the column and 20 in the row. like chart below. <table style="border-collapse: collapse; width: 1008pt;" width="1344" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64" span="21"> <tbody><tr style="height: 19.5pt;" height="26"> <td class="xl74" style="height: 19.5pt; width: 48pt;" width="64" height="26">tps rpm</td> <td class="xl74" style="width: 48pt;" width="64">10700</td> <td class="xl74" style="width: 48pt;" width="64">10000</td> <td class="xl74" style="width: 48pt;" width="64">9200</td> <td class="xl74" style="width: 48pt;" width="64">8400</td> <td class="xl74" style="width: 48pt;" width="64">7700</td> <td class="xl74" style="width: 48pt;" width="64">6900</td> <td class="xl74" style="width: 48pt;" width="64">6100</td> <td class="xl74" style="width: 48pt;" width="64">5500</td> <td class="xl74" style="width: 48pt;" width="64">5000</td> <td class="xl74" style="width: 48pt;" width="64">4500</td> <td class="xl74" style="width: 48pt;" width="64">4000</td> <td class="xl74" style="width: 48pt;" width="64">3500</td> <td class="xl74" style="width: 48pt;" width="64">3000</td> <td class="xl74" style="width: 48pt;" width="64">2500</td> <td class="xl74" style="width: 48pt;" width="64">2000</td> <td class="xl74" style="width: 48pt;" width="64">1700</td> <td class="xl74" style="width: 48pt;" width="64">1400</td> <td class="xl74" style="width: 48pt;" width="64">1200</td> <td class="xl74" style="width: 48pt;" width="64">1000</td> <td class="xl74" style="width: 48pt;" width="64">400</td> </tr> <tr style="height: 23.25pt;" height="31"> <td class="xl75" style="height: 23.25pt;" height="31">255</td> <td class="xl76">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> <td class="xl76" style="border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">175</td> <td class="xl77" style="border-top: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">125</td> <td class="xl76" style="border-top: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">100</td> <td class="xl77" style="border-top: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">80</td> <td class="xl76" style="border-top: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">60</td> <td class="xl77" style="border-top: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">45</td> <td class="xl76" style="border-top: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">35</td> <td class="xl77" style="border-top: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">30</td> <td class="xl76" style="border-top: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">26</td> <td class="xl77" style="border-top: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">22</td> <td class="xl76" style="border-top: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">18</td> <td class="xl77" style="border-top: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">16</td> <td class="xl76" style="border-top: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">12</td> <td class="xl77" style="border-top: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">10</td> <td class="xl76" style="border-top: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl75" style="height: 22.5pt; border-top: medium none;" height="30">7</td> <td class="xl77" style="border-top: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> <td class="xl77" style="border-top: medium none; border-left: medium none;"></td> </tr> </tbody></table>



what I want to do is to be able to select a item from the single drop box and it will update all the cells in the chart headings row and columns per item type. not single tic boxes per cell.

I need this because the items in the headings are different per device and hand changing them every time I change devices has gotten old. the data in the chart is a cut copy paste from another program. i only need headings for each chart as a single drop box and not a selection for every cell.

I have a total of 10 different devices same cell size on sheet 3, I need this to go to sheet one. my sheet two is referenced from absolute data in sheet 1. which is the primary input sheet.

I can email out the sheet if this is a complex item to have added. If it will take VB code i will really need help:confused:

thanks

mike
 
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
941
smozgur
smozgur
C
  • Question Question
Macro Help - Transposing Some Data from Columns to Rows, Accounting for Duplicate Data
Replies
1
Views
186
Kaper
Kaper
P
  • Question Question
Select the time from the list and search with Selenium VBA
Replies
6
Views
825
John_w
J
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
1K
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C

Share this page

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