Please Help Complex Data Manipulation!

H

HeyItsTJ4

New Member
Joined
May 2, 2011
Messages
9
I am in desperate need of some assistance, this is due as of yesterday. I have a worksheet that has Name, Address, Dog name, etc. for a Dock Dog competition. I need the data pulled to new worksheets, according to what time slot the Dog and Handler is signed up for, then I would like to sort the new time slot sheet by the score that is manually input. I have the time slot worksheets, in the workbook already so you will know how it looks when manually input. Thanks in advance for any help.

You can download the workbook here to help me out:
online backup
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
Maybe I used the wrong title, and I can't figure out how to edit my post. VBA/Macro/Formula help, please.
 
Upvote 0
Hello,
Could you please paste the sample data(worksheet that has Name, Address, Dog name, etc) here?
Additionally please provide the template of the summary worksheet you aare looking for (data pulled to new worksheets, according to what time slot the Dog and Handler is signed up ).

Regards,
Kunal
 
Upvote 0
kunal_shrivastava said:
Hello,
Could you please paste the sample data(worksheet that has Name, Address, Dog name, etc) here?
Additionally please provide the template of the summary worksheet you aare looking for (data pulled to new worksheets, according to what time slot the Dog and Handler is signed up ).

Regards,
Kunal
Click to expand...
I have the workbook link on my upload server, it is about 2.5 MB. Click where it says download file, or online backup on my original post. Or here is the link to my workbook, http://www.filedropper.com/ruckerrunningordertestfile Thank you Kunal
 
Upvote 0
Hi,
I am not able to download the file due to network security.
Can you please paste the sample data of the two sheets you mentioned.

Regards,
Kunal
 
Upvote 0
<table width="1966" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:1974;width:41pt" width="54"> <col style="mso-width-source:userset;mso-width-alt:4790;width:98pt" width="131"> <col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> <col style="mso-width-source:userset;mso-width-alt:4790;width:98pt" width="131"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:3328;width:68pt" width="91"> <col style="mso-width-source:userset;mso-width-alt:1792;width:37pt" width="49"> <col style="mso-width-source:userset;mso-width-alt:5888;width:121pt" width="161"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:6034;width:124pt" width="165"> <col style="mso-width-source:userset;mso-width-alt:841;width:17pt" width="23"> <col style="mso-width-source:userset;mso-width-alt:329;width:7pt" width="9"> <col style="mso-width-source:userset;mso-width-alt:2486; width:51pt" width="68" span="3"> <col style="mso-width-source:userset;mso-width-alt:2486; width:51pt" width="68" span="6"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:3840;width:79pt" width="105"> <tbody><tr style="mso-height-source:userset;height:18.75pt" height="25"> <td colspan="22" class="xl81" style="height: 18.75pt;mso-ignore:colspan;width:1296pt" width="1725" align="center" height="25">2011 Dixie DockDogs-Rucker Jump Into Summer - Cumming, GA</td> <td class="xl84" style="width:51pt" width="68"> </td> <td class="xl81" style="width:51pt" width="68">
</td> <td class="xl81" style="width:79pt" width="105">
</td> </tr> <tr style="mso-height-source:userset;height:12.0pt" height="16"> <td colspan="22" class="xl83" style="height:12.0pt; mso-ignore:colspan" align="center" height="16">April 15-17, 2011</td> <td class="xl85"> </td> <td class="xl83">
</td> <td class="xl82">
</td> </tr> <tr style="height:11.25pt" height="15"> <td class="xl65" style="height:11.25pt" height="15">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl67">BA1</td> <td class="xl67" style="border-left:none">BA2</td> <td class="xl67" style="border-left:none">BA3</td> <td class="xl67" style="border-left:none">BA4</td> <td class="xl67" style="border-left:none">BA5</td> <td class="xl67" style="border-left:none">BA6</td> <td class="xl67" style="border-left:none">BA7</td> <td class="xl67" style="border-left:none">SR1</td> <td class="xl67" style="border-left:none">SR2</td> <td class="xl86" style="border-left:none">EV</td> <td class="xl67" style="border-left:none">ID</td> <td class="xl68" style="border-left:none"> </td> </tr> <tr style="height:11.25pt" height="15"> <td class="xl69" style="height:11.25pt" height="15">Reg</td> <td class="xl66">H_Name</td> <td class="xl66">D_Name</td> <td class="xl66">D_Breed</td> <td class="xl66">D_Sex</td> <td class="xl66">D_Age</td> <td class="xl66">Hometown</td> <td class="xl66">Title</td> <td class="xl70">Address</td> <td class="xl66">H_Phone</td> <td class="xl66">H_Email</td> <td class="xl66">H_Junior</td> <td class="xl66">Junior Mult</td> <td class="xl71">Fri 12pm</td> <td class="xl71" style="border-left:none">Fri 230pm</td> <td class="xl71" style="border-left:none">Sat 9am</td> <td class="xl71" style="border-left:none">Sat 1030am</td> <td class="xl71" style="border-left:none">Sat 12pm</td> <td class="xl71" style="border-left:none">Sat 2pm</td> <td class="xl71" style="border-left:none">Sun 12:00pm</td> <td class="xl71" style="border-left:none">Fri 430pm</td> <td class="xl71" style="border-left:none">Sat 430pm</td> <td class="xl87" style="border-left:none">Sun 10am</td> <td class="xl71" style="border-left:none"> </td> <td class="xl72" style="border-left:none">Entry</td> </tr> <tr style="mso-height-source:userset;height:4.5pt" height="6"> <td class="xl65" style="height:4.5pt" height="6">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl69">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl73">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl74"> </td> <td class="xl74" style="border-left:none"> </td> <td class="xl74" style="border-left:none"> </td> <td class="xl74" style="border-left:none"> </td> <td class="xl74" style="border-left:none"> </td> <td class="xl74" style="border-left:none"> </td> <td class="xl74" style="border-left:none"> </td> <td class="xl74" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl74" style="border-left:none"> </td> <td class="xl75" style="border-left:none"> </td> </tr> <tr style="mso-height-source:userset;height:38.1pt" height="50"> <td class="xl91" style="height:38.1pt;width:41pt" width="54" height="50">PRE REG</td> <td class="xl79" style="border-left:none;width:98pt" width="131"> </td> <td class="xl79" style="border-left:none;width:53pt" width="70">Charlie Buckett</td> <td class="xl79" style="border-left:none;width:98pt" width="131">Labrador Retriever Black</td> <td class="xl79" style="border-left:none;width:46pt" width="61">M</td> <td class="xl80" style="border-left:none;width:65pt" width="86">11/16/2008</td> <td class="xl79" style="border-left:none;width:68pt" width="91">McDonough, GA</td> <td class="xl79" style="border-left:none;width:37pt" width="49">Senior Top Gun</td> <td class="xl79" style="border-left:none;width:121pt" width="161"> </td> <td class="xl79" style="border-left:none;width:62pt" width="82"> </td> <td class="xl79" style="border-left:none;width:124pt" width="165"> </td> <td class="xl79" style="border-left:none;width:17pt" width="23"> </td> <td class="xl79" style="border-left:none;width:7pt" width="9"> </td> <td class="xl76" style="border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-left:none;width:51pt" width="68">1</td> <td class="xl76" style="border-left:none;width:51pt" width="68">1</td> <td class="xl76" style="border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-left:none;width:51pt" width="68">1</td> <td class="xl89" style="border-left:none;width:51pt" width="68">1</td> <td class="xl76" style="border-left:none;width:51pt" width="68">1</td> <td class="xl78" style="border-left:none">$105.00 </td> </tr> <tr style="mso-height-source:userset;height:38.1pt" height="50"> <td class="xl91" style="height:38.1pt;border-top:none; width:41pt" width="54" height="50">PRE REG</td> <td class="xl79" style="border-top:none;border-left:none;width:98pt" width="131"> </td> <td class="xl79" style="border-top:none;border-left:none;width:53pt" width="70">Zoe</td> <td class="xl79" style="border-top:none;border-left:none;width:98pt" width="131">Mixed</td> <td class="xl79" style="border-top:none;border-left:none;width:46pt" width="61">F</td> <td class="xl80" style="border-top:none;border-left:none;width:65pt" width="86">2/1/2009</td> <td class="xl79" style="border-top:none;border-left:none;width:68pt" width="91">Cumming, GA</td> <td class="xl79" style="border-top:none;border-left:none;width:37pt" width="49"> </td> <td class="xl79" style="border-top:none;border-left:none;width:121pt" width="161"> </td> <td class="xl79" style="border-top:none;border-left:none;width:62pt" width="82"> </td> <td class="xl79" style="border-top:none;border-left:none;width:124pt" width="165"> </td> <td class="xl79" style="border-top:none;border-left:none;width:17pt" width="23">Y</td> <td class="xl79" style="border-top:none;border-left:none;width:7pt" width="9"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68">1</td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl89" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl78" style="border-top:none;border-left:none">$10.00 </td> </tr> <tr style="mso-height-source:userset;height:38.1pt" height="50"> <td class="xl91" style="height:38.1pt;border-top:none; width:41pt" width="54" height="50">PRE REG</td> <td class="xl79" style="border-top:none;border-left:none;width:98pt" width="131"> </td> <td class="xl79" style="border-top:none;border-left:none;width:53pt" width="70">Cooper</td> <td class="xl79" style="border-top:none;border-left:none;width:98pt" width="131">German Shorthaired Pointer</td> <td class="xl79" style="border-top:none;border-left:none;width:46pt" width="61">M</td> <td class="xl80" style="border-top:none;border-left:none;width:65pt" width="86">4/1/2010</td> <td class="xl79" style="border-top:none;border-left:none;width:68pt" width="91">Charleston, SC</td> <td class="xl79" style="border-top:none;border-left:none;width:37pt" width="49"> </td> <td class="xl79" style="border-top:none;border-left:none;width:121pt" width="161"> </td> <td class="xl79" style="border-top:none;border-left:none;width:62pt" width="82"> </td> <td class="xl79" style="border-top:none;border-left:none;width:124pt" width="165"> </td> <td class="xl79" style="border-top:none;border-left:none;width:17pt" width="23"> </td> <td class="xl79" style="border-top:none;border-left:none;width:7pt" width="9"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68">1</td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68">1</td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl89" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl76" style="border-top:none;border-left:none;width:51pt" width="68"> </td> <td class="xl78" style="border-top:none;border-left:none">$40.00 </td> </tr> </tbody></table>
 
Upvote 0
<table width="986" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:877;width:18pt" width="24"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> <col style="mso-width-source:userset;mso-width-alt:3254;width:67pt" width="89"> <col style="mso-width-source:userset;mso-width-alt:3328;width:68pt" width="91"> <col style="mso-width-source:userset;mso-width-alt:1206;width:25pt" width="33"> <col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:4022;width:83pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:2742; width:56pt" width="75" span="2"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2267;width:47pt" width="62"> <col style="mso-width-source:userset;mso-width-alt:1645;width:34pt" width="45"> <col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> <tbody><tr style="mso-height-source:userset;height:18.0pt" height="24"> <td style="height:18.0pt;width:18pt" width="24" height="24">
</td> <td colspan="6" class="xl93" style="width:383pt" width="509">Rucker Jump Into Summer</td> <td class="xl68" style="width:38pt" width="51">
</td> <td colspan="5" class="xl97" style="border-right:.5pt solid black; width:249pt" width="332">I verify and certify that the results on this page are an</td> <td style="width:53pt" width="70">
</td> </tr> <tr style="mso-height-source:userset;height:18.0pt" height="24"> <td style="height:18.0pt" height="24">
</td> <td colspan="6" class="xl93">Cumming, GA</td> <td class="xl69">
</td> <td colspan="5" class="xl100" style="border-right:.5pt solid black">accurate record of this DockDogs competition:</td> <td>
</td> </tr> <tr style="mso-height-source:userset;height:18.0pt" height="24"> <td style="height:18.0pt" height="24">
</td> <td colspan="6" class="xl93">Friday, April 15, 2011 -- 12:00 PM</td> <td class="xl69">
</td> <td colspan="5" class="xl94" style="border-right:.5pt solid black">JUDGES: </td> <td>
</td> </tr> <tr style="mso-height-source:userset;height:18.0pt" height="24"> <td style="height:18.0pt" height="24">
</td> <td colspan="6" class="xl93">BIG AIR WAVE #1</td> <td class="xl70">
</td> <td colspan="5" class="xl94" style="border-right:.5pt solid black">SECRETARY: </td> <td>
</td> </tr> <tr style="mso-height-source:userset;height:12.0pt" height="16"> <td style="height:12.0pt" height="16">
</td> <td class="xl71" style="width:88pt" width="117">
</td> <td class="xl72">
</td> <td class="xl72">
</td> <td class="xl72">
</td> <td class="xl73">
</td> <td class="xl72">
</td> <td class="xl72">
</td> <td class="xl74"> </td> <td class="xl75"> </td> <td class="xl75"> </td> <td class="xl75"> </td> <td class="xl76"> </td> <td>
</td> </tr> <tr style="mso-height-source:userset;height:12.0pt" height="16"> <td style="height:12.0pt" height="16">
</td> <td class="xl71" style="width:88pt" width="117">
</td> <td class="xl72">
</td> <td class="xl72">
</td> <td class="xl72">
</td> <td class="xl73">
</td> <td class="xl72">
</td> <td class="xl72">
</td> <td class="xl77">
</td> <td class="xl77">
</td> <td class="xl77">
</td> <td class="xl77">
</td> <td class="xl77">
</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td class="xl78" style="width:88pt" width="117">H_Name</td> <td class="xl79">D_Name</td> <td class="xl79">Breed</td> <td class="xl79">Sex</td> <td class="xl73">Age</td> <td class="xl79">Hometown</td> <td class="xl79">Title</td> <td class="xl79">JUMP #1</td> <td class="xl79">JUMP #2</td> <td class="xl79">SCORE</td> <td class="xl79">DIV. </td> <td class="xl80">PLACE</td> <td class="xl81">RC CONT.</td> </tr> <tr style="mso-height-source:userset;height:21.75pt" height="29"> <td class="xl82" style="height:21.75pt" height="29">1</td> <td class="xl91" style="border-left:none;width:88pt" width="117"> </td> <td class="xl91" style="border-left:none;width:67pt" width="89">Charolotte</td> <td class="xl91" style="border-left:none;width:68pt" width="91">Rat Terrier</td> <td class="xl91" style="border-left:none;width:25pt" width="33">f</td> <td class="xl92" style="border-left:none;width:52pt" width="69">9/8/2008</td> <td class="xl91" style="border-left:none;width:83pt" width="110">Dawsonville GA</td> <td class="xl66" style="border-left:none;width:38pt" width="51"> </td> <td class="xl83" style="border-left:none">9.10</td> <td class="xl83" style="border-left:none">7.06</td> <td class="xl84" style="border-left:none">9.10</td> <td class="xl85" style="border-left:none">Novice</td> <td class="xl86" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> </tr> <tr style="mso-height-source:userset;height:21.75pt" height="29"> <td class="xl82" style="height:21.75pt;border-top:none" height="29">2</td> <td class="xl66" style="border-top:none;border-left:none;width:88pt" width="117"> </td> <td class="xl66" style="border-top:none;border-left:none;width:67pt" width="89">Rockne</td> <td class="xl66" style="border-top:none;border-left:none;width:68pt" width="91">Golden Retriever</td> <td class="xl66" style="border-top:none;border-left:none;width:25pt" width="33">M</td> <td class="xl67" style="border-top:none;border-left:none;width:52pt" width="69">7/12/2007</td> <td class="xl66" style="border-top:none;border-left:none;width:83pt" width="110">Cumming, GA</td> <td class="xl66" style="border-top:none;border-left:none;width:38pt" width="51"> </td> <td class="xl88" style="border-top:none;border-left:none">6.05</td> <td class="xl88" style="border-top:none;border-left:none">6.06</td> <td class="xl84" style="border-top:none;border-left:none">6.06</td> <td class="xl85" style="border-top:none;border-left:none">Novice</td> <td class="xl86" style="border-top:none;border-left:none"> </td> <td class="xl87" style="border-top:none;border-left:none"> </td> </tr> <tr style="mso-height-source:userset;height:21.75pt" height="29"> <td class="xl82" style="height:21.75pt;border-top:none" height="29">3</td> <td class="xl66" style="border-top:none;border-left:none;width:88pt" width="117"> </td> <td class="xl66" style="border-top:none;border-left:none;width:67pt" width="89">Alice</td> <td class="xl66" style="border-top:none;border-left:none;width:68pt" width="91">Labrador Retriever Yellow</td> <td class="xl66" style="border-top:none;border-left:none;width:25pt" width="33"> </td> <td class="xl67" style="border-top:none;border-left:none;width:52pt" width="69">11/28/2009</td> <td class="xl66" style="border-top:none;border-left:none;width:83pt" width="110">Douglasville, GA</td> <td class="xl66" style="border-top:none;border-left:none;width:38pt" width="51"> </td> <td class="xl88" style="border-top:none;border-left:none">12.03</td> <td class="xl88" style="border-top:none;border-left:none">9.06</td> <td class="xl84" style="border-top:none;border-left:none">12.03</td> <td class="xl85" style="border-top:none;border-left:none">Junior</td> <td class="xl86" style="border-top:none;border-left:none"> </td> <td class="xl87" style="border-top:none;border-left:none"> </td> </tr> </tbody></table>
 
Upvote 0
Hi,
Please confirm my understanding:
1. A new worksheet needs to populated based on the data in the worksheet sample data posted in last two messages of yours.
2. The new worksheet will contain data as shown below:
<TABLE style="WIDTH: 928pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1232 border=0><COLGROUP><COL style="WIDTH: 116pt" span=8 width=154><TBODY><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl65 id=td_post_2704558 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: #efefef" width=154 height=22>D_Name</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>D_Breed</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>D_Sex</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>D_Age</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Hometown</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Title</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Time Slot</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>SCORE</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: #efefef" width=154 height=22>Charlie Buckett</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Labrador Retriever Black</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>M</TD><TD class=xl67 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=154>11/16/2008</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>McDonough, GA</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Senior Top Gun</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Sat 12pm</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=154>9.1</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: #efefef" width=154 height=22>Charlie Buckett</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Labrador Retriever Black</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>M</TD><TD class=xl67 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=154>11/17/2008</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>McDonough, GA</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Senior Top Gun</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Sat 2pm</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=154>9.1</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: #efefef" width=154 height=22>Charlie Buckett</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Labrador Retriever Black</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>M</TD><TD class=xl67 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=154>11/18/2008</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>McDonough, GA</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Senior Top Gun</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=154>Sat 430pm</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #3867a6; WIDTH: 116pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=154>9.1</TD></TR></TBODY></TABLE>
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question Question
Generate lists based on Column information
Replies
6
Views
769
JerrExcel
JerrExcel
T
  • Question Question
Automatically Copying Data To A New Workbook When Closing A Workbook
Replies
4
Views
467
Tmini
T
S
  • Solved
Using User form to load workbook, extract and combine desired data into new workbook or worksheet
2
Replies
10
Views
676
mumps
mumps
M
  • Question Question
VBA code to find a match then sort data in order based on two separate columns
Replies
0
Views
812
mustacheman
M
S
  • Question Question
Data Linking into Calendar
Replies
0
Views
533
Steph123
S

Forum statistics

Threads
1,224,583
Messages
6,179,678
Members
452,937
Latest member
Bhg1984

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