Dynamic Named Range (Excel 2003)

Z

Zyniker

New Member
Joined
Feb 17, 2009
Messages
27
So, basically what I want to accomplish is this:
I have a sizable workbook that stores discovery information for a series of legal cases. There are a total of six pertinent sheets, any particular case will appear on two of those sheets. (Three sheets are for defendant discovery, three are for plaintiff discovery.) I currently have the information pertaining to each individual case as a named range (such as: NameDEF or NamePLTF, depending upon worksheet). What I would like to do is convert these to dynamic named ranges so that I don't have to manually update them every time a new piece of discovery is received or some case information changes.
The setup for the information is as follows:

<table x:str="" style="border-collapse: collapse; width: 869pt;" width="1159" border="0" cellpadding="0" cellspacing="0"><col style="width: 85pt;" width="113"> <col style="width: 48pt;" width="64"> <col style="width: 130pt;" width="173"> <col style="width: 188pt;" width="250"> <col style="width: 56pt;" width="75"> <col style="width: 35pt;" width="47"> <col style="width: 83pt;" width="111"> <col style="width: 51pt;" width="68"> <col style="width: 83pt;" width="111"> <col style="width: 51pt;" width="68"> <col style="width: 59pt;" width="79"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 85pt;" width="113" height="17">Smith</td> <td class="xl24" style="width: 48pt;" x:num="8" width="64" align="right">008</td> <td class="xl24" style="width: 130pt;" width="173">DEF01</td> <td class="xl24" style="width: 188pt;" width="250">PLTF01-01</td> <td class="xl25" style="background: silver none repeat scroll 0% 0%; width: 56pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="75">MROGS</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" width="47" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="111">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="68">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39671" width="111">11-Aug-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="68">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;" width="79">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">MROGS</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="1" align="right">01</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" x:num="39675">15-Aug-2008</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">GOROGS</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="" align="right">15</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39794">12-Dec-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">F+L</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">GOROGS</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="" align="right">13</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" x:num="39729">8-Oct-2008</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">F+L</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">MROGS</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39766">14-Nov-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">F+L</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl24">DEF02</td> <td class="xl24">PLTF02-01</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">GOROGS</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39671">11-Aug-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl24">DEF03</td> <td class="xl24">PLTF03-01</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RPD</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38398">15-Feb-2005</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">SPROGS</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="1" align="right">01</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" x:num="38398">15-Feb-2005</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" x:num="39772">20-Nov-2008</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl24">PLTF03-02</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RFA</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38396">13-Feb-2005</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl24">PLTF03-03</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RFA</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38740">23-Jan-2006</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl24">DEF04</td> <td class="xl24">PLTF04-01</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RFA</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39100">18-Jan-2007</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl24">PLTF04-02</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RFA</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl24">PLTF04-03</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">GOROGS</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="" align="right">29</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38698">12-Dec-2005</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">RPD</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="1" align="right">01</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" x:num="38697">11-Dec-2005</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" x:num="39772">20-Nov-2008</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">SPROGS</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" align="right">01</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38696">10-Dec-2005</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl28" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl26" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl27" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> </tr> </tbody></table>
Click to expand...
I would like for the dynamic named range to be determined by the first column of information (the case name, in this example "Smith") and the sheet on which it appears. The second requirement is key as there will be two ranges of cells that appear to the right of a cell with "Smith" in it (one for the DEF sheet, one for the PLTF sheet).

Any help will be much appreciated!
 

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
In case anyone was confused: there is a column between the acronyms and the dates (even though it was rather squished together when quoted and looks like 0110-Dec-2005 is a date).
 
Upvote 0
Another bit of information that may possibly be of help:
After each section, there is a blank, merged cell across the bottom of the section. It would be a trivial matter to put a value in these cells if that would help delineate where a section ends.
 
Upvote 0
<table x:str="" style="border-collapse: collapse; width: 597pt;" width="799" border="0" cellpadding="0" cellspacing="0"><col style="width: 44pt;" width="59"> <col style="width: 26pt;" width="35"> <col style="width: 47pt;" width="63"> <col style="width: 62pt;" width="83"> <col style="width: 56pt;" width="75"> <col style="width: 35pt;" width="47"> <col style="width: 83pt;" width="111"> <col style="width: 51pt;" width="68"> <col style="width: 83pt;" width="111"> <col style="width: 51pt;" width="68"> <col style="width: 59pt;" width="79"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; width: 44pt;" width="59" height="17">Smith</td> <td class="xl27" style="width: 26pt;" x:num="8" width="35">008</td> <td class="xl27" style="width: 47pt;" width="63">DEF01</td> <td class="xl27" style="width: 62pt;" width="83">PLTF01-01</td> <td class="xl25" style="background: silver none repeat scroll 0% 0%; width: 56pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="75">MROGS</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1" width="47">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="111">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="68">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39671" width="111">11-Aug-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="68">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;" width="79">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">MROGS</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" x:num="1">01</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="39675">15-Aug-2008</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">GOROGS</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="">15</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39794">12-Dec-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">F+L</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">GOROGS</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" x:num="">13</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="39729">8-Oct-2008</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">F+L</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">MROGS</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39766">14-Nov-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">F+L</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl27">DEF02</td> <td class="xl27">PLTF02-01</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">GOROGS</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39671">11-Aug-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl27">DEF03</td> <td class="xl27">PLTF03-01</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RPD</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38398">15-Feb-2005</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">SPROGS</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" x:num="1">01</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="38398">15-Feb-2005</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="39772">20-Nov-2008</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl27">PLTF03-02</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RFA</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38396">13-Feb-2005</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl27">PLTF03-03</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RFA</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38740">23-Jan-2006</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl27">DEF04</td> <td class="xl27">PLTF04-01</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RFA</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39100">18-Jan-2007</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl27">PLTF04-02</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">RFA</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl27">PLTF04-03</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">GOROGS</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="">29</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38698">12-Dec-2005</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">RPD</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" x:num="1">01</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="38697">11-Dec-2005</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="39772">20-Nov-2008</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">SPROGS</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="1">01</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="38696">10-Dec-2005</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" x:num="39772">20-Nov-2008</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LTR</td> <td class="xl25" style="border: 0.5pt solid green; color: green; font-weight: 700;">Yes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl29">
</td> <td class="xl25" style="border-top: medium none; background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl28" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl24" style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">
</td> </tr> </tbody></table>
Click to expand...
This may be a little easier to read/assess than the previously posted version. Start of section = Smith; End of section = lower right corner.
 
Upvote 0
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
537
smozgur
smozgur
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A
A
  • Locked
  • Question Question
values across tables found by name
Replies
2
Views
481
Fluff
Fluff

Forum statistics

Threads
1,223,236
Messages
6,170,915
Members
452,366
Latest member
TePunaBloke

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