Pls help to solve this, by formula or code, find attachd sample file
<table border="0" cellpadding="0" cellspacing="0" width="411"><col style="width:42pt" span="3" width="56"> <col style="mso-width-source:userset;mso-width-alt:3968;width:70pt" width="93"> <col style="mso-width-source:userset;mso-width-alt:3370;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:3029;width:53pt" width="71"> <tbody><tr style="height:12.0pt" height="16"> <td class="xl68" style="height:12.0pt;width:42pt" height="16" width="56">Channel</td> <td class="xl68" style="width:42pt" width="56">Time</td> <td class="xl68" style="width:42pt" width="56"> Date</td> <td class="xl68" style="width:70pt" width="93"> Day</td> <td class="xl68" style="width:59pt" width="79">Task</td> <td style="width:53pt" width="71">
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Marc</td> <td class="xl64" align="right">7:00</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Cleang</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Marc</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Stiching</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Marc</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Clubing</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Marc</td> <td class="xl64" align="right">8:30</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Xfile</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Hope</td> <td class="xl64" align="right">13:00</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Tuning</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Hope</td> <td class="xl64" align="right">13:30</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Lock</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Hope</td> <td class="xl64" align="right">14:00</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Feed</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Steve</td> <td class="xl64" align="right">6:00</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Genrate</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Steve</td> <td class="xl64" align="right">6:30</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Sale</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Steve</td> <td class="xl64" align="right">6:30</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Work</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:00</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Feed</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Lock</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Cleang</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:00</td> <td class="xl63" align="center">########</td> <td>Wed</td> <td>Van</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Wed</td> <td>Store</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Wed</td> <td>Checking</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">
</td> <td class="xl64">
</td> <td class="xl63">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl68" colspan="6" style="height:12.0pt;mso-ignore:colspan" height="16">Is this possible in excel by VBA code to get this info from above table</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">
</td> <td class="xl64">
</td> <td class="xl63">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl66" style="height:12.0pt" height="16"> Day</td> <td class="xl66">Time</td> <td class="xl66">Hope</td> <td class="xl66">Marc</td> <td class="xl66">Steve</td> <td class="xl66">Teddy</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">Tue</td> <td class="xl64" align="right">6:00</td> <td>
</td> <td>
</td> <td>Genrate</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">6:30</td> <td>
</td> <td>
</td> <td>Sale;Work</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">7:00</td> <td>
</td> <td>
</td> <td>
</td> <td>Feed</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl67" style="height:12.0pt" height="16"> </td> <td class="xl64" align="right">7:30</td> <td>
</td> <td>
</td> <td>
</td> <td>Lock;Cleang</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">Wed</td> <td class="xl64" align="right">7:00</td> <td>
</td> <td>
</td> <td>
</td> <td>Van</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl67" style="height:12.0pt" height="16"> </td> <td class="xl64" align="right">7:30</td> <td>
</td> <td>
</td> <td>
</td> <td>Store;Checking</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">Sat</td> <td class="xl64" align="right">7:00</td> <td>
</td> <td>Cleang</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">7:30</td> <td>
</td> <td>Stiching;Clubing</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">8:30</td> <td>
</td> <td>Xfile</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">13:00</td> <td>Tuning</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">13:30</td> <td>Lock</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl67" style="height:12.0pt" height="16"> </td> <td class="xl64" align="right">14:00</td> <td>Feed</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>
<table border="0" cellpadding="0" cellspacing="0" width="411"><col style="width:42pt" span="3" width="56"> <col style="mso-width-source:userset;mso-width-alt:3968;width:70pt" width="93"> <col style="mso-width-source:userset;mso-width-alt:3370;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:3029;width:53pt" width="71"> <tbody><tr style="height:12.0pt" height="16"> <td class="xl68" style="height:12.0pt;width:42pt" height="16" width="56">Channel</td> <td class="xl68" style="width:42pt" width="56">Time</td> <td class="xl68" style="width:42pt" width="56"> Date</td> <td class="xl68" style="width:70pt" width="93"> Day</td> <td class="xl68" style="width:59pt" width="79">Task</td> <td style="width:53pt" width="71">
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Marc</td> <td class="xl64" align="right">7:00</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Cleang</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Marc</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Stiching</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Marc</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Clubing</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Marc</td> <td class="xl64" align="right">8:30</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Xfile</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Hope</td> <td class="xl64" align="right">13:00</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Tuning</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Hope</td> <td class="xl64" align="right">13:30</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Lock</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Hope</td> <td class="xl64" align="right">14:00</td> <td class="xl63" align="center">########</td> <td>Sat</td> <td>Feed</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Steve</td> <td class="xl64" align="right">6:00</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Genrate</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Steve</td> <td class="xl64" align="right">6:30</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Sale</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Steve</td> <td class="xl64" align="right">6:30</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Work</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:00</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Feed</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Lock</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Tue</td> <td>Cleang</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:00</td> <td class="xl63" align="center">########</td> <td>Wed</td> <td>Van</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Wed</td> <td>Store</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">Teddy</td> <td class="xl64" align="right">7:30</td> <td class="xl63" align="center">########</td> <td>Wed</td> <td>Checking</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">
</td> <td class="xl64">
</td> <td class="xl63">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl68" colspan="6" style="height:12.0pt;mso-ignore:colspan" height="16">Is this possible in excel by VBA code to get this info from above table</td> </tr> <tr style="height:12.0pt" height="16"> <td style="height:12.0pt" height="16">
</td> <td class="xl64">
</td> <td class="xl63">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl66" style="height:12.0pt" height="16"> Day</td> <td class="xl66">Time</td> <td class="xl66">Hope</td> <td class="xl66">Marc</td> <td class="xl66">Steve</td> <td class="xl66">Teddy</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">Tue</td> <td class="xl64" align="right">6:00</td> <td>
</td> <td>
</td> <td>Genrate</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">6:30</td> <td>
</td> <td>
</td> <td>Sale;Work</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">7:00</td> <td>
</td> <td>
</td> <td>
</td> <td>Feed</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl67" style="height:12.0pt" height="16"> </td> <td class="xl64" align="right">7:30</td> <td>
</td> <td>
</td> <td>
</td> <td>Lock;Cleang</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">Wed</td> <td class="xl64" align="right">7:00</td> <td>
</td> <td>
</td> <td>
</td> <td>Van</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl67" style="height:12.0pt" height="16"> </td> <td class="xl64" align="right">7:30</td> <td>
</td> <td>
</td> <td>
</td> <td>Store;Checking</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">Sat</td> <td class="xl64" align="right">7:00</td> <td>
</td> <td>Cleang</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">7:30</td> <td>
</td> <td>Stiching;Clubing</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">8:30</td> <td>
</td> <td>Xfile</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">13:00</td> <td>Tuning</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl65" style="height:12.0pt" height="16">
</td> <td class="xl64" align="right">13:30</td> <td>Lock</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl67" style="height:12.0pt" height="16"> </td> <td class="xl64" align="right">14:00</td> <td>Feed</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>