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
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

P
  • Question
Select the time from the list and search with Selenium VBA
Replies
6
Views
245
John_w
J
E
  • Question
VBA for Web Scraping help
Replies
0
Views
606
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
D
  • Question
Problems Encountered When Generating VBA Excel Charts with 15-Minute Interval Data.
Replies
0
Views
169
dilshod_k
D
M
  • Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M

Forum statistics

Threads
1,215,479
Messages
6,125,041
Members
449,206
Latest member
Healthydogs

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