table colum

S

sudburymetoo

Board Regular
Joined
Dec 15, 2008
Messages
59
<table class="MsoNormalTable" style="width: 230pt; margin-left: 4.65pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="307"> <tbody><tr style="height: 15pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap"> service area<o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap"> Fries<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap">
1<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
2<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
3<o:p></o:p>​
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap"> rings<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap">
1<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap"> Pretzels<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap">
4<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
5<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
6<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
7<o:p></o:p>​
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap"> Steak<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap">
5<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
6<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
7<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap"> popcorn<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap">
3<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
4<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
5<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
6<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
7<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap"> Bbq chicken<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap">
2<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
7<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap"> Frites<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap">
3<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
4<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
5<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
1<o:p></o:p>​
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap"> Fries,,rings<o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
2<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap"> fries,bbq chicken<o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
3<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap"> fries,popcorn,frites<o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
4<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 114pt; height: 15pt;" valign="bottom" width="152" nowrap="nowrap"> pretzels,popcorn,frites<o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 11pt; height: 15pt;" valign="bottom" width="15" nowrap="nowrap">
</td> </tr> </tbody></table> <o:p> </o:p>
<o:p> </o:p>
How do I change table 1 into table 2, Any help Thank you<o:p></o:p>
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
try this macro "test" the result is in sheet 2
the result is not exactly as in the format require but very similar to that

Code: 
Sub test()
Dim j As Integer, cfind As Range, area As String, r As Range, add As String
With Worksheets("sheet1")
For j = 1 To 7

Set cfind = .Cells.Find(what:=j, lookat:=xlWhole)
If cfind Is Nothing Then GoTo nextj
add = cfind.Address
area = .Cells(cfind.Row, 1).Value
MsgBox area
With Worksheets("sheet2")
Set r = .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
r = j
.Cells(r.Row, Columns.Count).End(xlToLeft).Offset(0, 1) = area
End With
Do
Set cfind = .Cells.FindNext(cfind)
If cfind Is Nothing Then Exit Do
If cfind.Address = add Then Exit Do
area = .Cells(cfind.Row, 1)

With Worksheets("sheet2")
Set r = .Cells(Rows.Count, "A").End(xlUp)

.Cells(r.Row, Columns.Count).End(xlToLeft).Offset(0, 1) = area
End With
Loop
nextj:
Next j
End With
End Sub


Code: 
Sub undo()
Worksheets("sheet2").Cells.Clear

End Sub
 
Upvote 0
<table class="MsoNormalTable" style="width: 257pt; margin-left: 4.65pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="343"> <tbody><tr style="height: 15pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 48pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
1<o:p></o:p>​
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 43pt; height: 15pt;" valign="bottom" width="57" nowrap="nowrap">
Fries<o:p></o:p>​
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
rings<o:p></o:p>​
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 44pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
1<o:p></o:p>​
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 48pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
2<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 43pt; height: 15pt;" valign="bottom" width="57" nowrap="nowrap">
Fries<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
Bbq chicken<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 44pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
2<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 48pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
3<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 43pt; height: 15pt;" valign="bottom" width="57" nowrap="nowrap">
Fries<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
popcorn<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 44pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
Frites<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
3<o:p></o:p>​
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 48pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
4<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 43pt; height: 15pt;" valign="bottom" width="57" nowrap="nowrap">
Pretzels<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
popcorn<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 44pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
Frites<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
4<o:p></o:p>​
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 48pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
5<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 43pt; height: 15pt;" valign="bottom" width="57" nowrap="nowrap">
Pretzels<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
Steak<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 44pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
popcorn<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
Frites<o:p></o:p>​
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 48pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
6<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 43pt; height: 15pt;" valign="bottom" width="57" nowrap="nowrap">
Pretzels<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
Steak<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 44pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
popcorn<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 48pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
7<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 43pt; height: 15pt;" valign="bottom" width="57" nowrap="nowrap">
Pretzels<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
Steak<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 44pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
popcorn<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61pt; height: 15pt;" valign="bottom" width="81" nowrap="nowrap">
Bbq chicken<o:p></o:p>​
</td> </tr> </tbody></table> <o:p> </o:p>
This is great, thanks for this. Two things.<o:p></o:p>
1,it prompts a message saying fries, pretzels which I have to hit ok.<o:p></o:p>
2)1,2,3,4 appear in the table ,which is not needed, though 5,6,7 does not appear.<o:p></o:p>
 
Upvote 0
introduce a single apstrophe (') at the beginning of the statemnt which begins like
msgbox .....
so that this line will be inoperable and no pop up message will come

your data is like thsi

Excel Workbook
ABCDEFG
1service area
2Fries123
3rings1
4Pretzels4567
5Steak567
6popcorn34567
7Bbq chicken27
8Frites345
Sheet1


after running the macro "test" sheet 2 will be like this

Excel Workbook
ABCDEF
1
21Friesrings
32FriesBbq chicken
43FriespopcornFrites
54PretzelspopcornFrites
65PretzelsSteakpopcornFrites
76PretzelsSteakpopcorn
87PretzelsSteakpopcornBbq chicken
Sheet2
 
Upvote 0
introduce a single apostrophe (') at the beginning of the statemnt which begins like
msgbox .....
so that this line will be inoperable and no pop up message will come

your data is like thsi

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >service area</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Fries</td><td style="text-align:right; ">1</td><td style="text-align:right; ">2</td><td > </td><td > </td><td > </td><td style="text-align:right; ">3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >rings</td><td style="text-align:right; ">1</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Pretzels</td><td style="text-align:right; ">4</td><td style="text-align:right; ">5</td><td > </td><td style="text-align:right; ">6</td><td style="text-align:right; ">7</td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Steak</td><td style="text-align:right; ">5</td><td style="text-align:right; ">6</td><td style="text-align:right; ">7</td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >popcorn</td><td style="text-align:right; ">3</td><td style="text-align:right; ">4</td><td style="text-align:right; ">5</td><td style="text-align:right; ">6</td><td style="text-align:right; ">7</td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Bbq chicken</td><td style="text-align:right; ">2</td><td style="text-align:right; ">7</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >Frites</td><td style="text-align:right; ">3</td><td style="text-align:right; ">4</td><td style="text-align:right; ">5</td><td > </td><td > </td><td > </td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4 </a>

after running the macro "test" sheet 2 will be like this

<b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">1</td><td >Fries</td><td >rings</td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">2</td><td >Fries</td><td >Bbq chicken</td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">3</td><td >Fries</td><td >popcorn</td><td >Frites</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">4</td><td >Pretzels</td><td >popcorn</td><td >Frites</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">5</td><td >Pretzels</td><td >Steak</td><td >popcorn</td><td >Frites</td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">6</td><td >Pretzels</td><td >Steak</td><td >popcorn</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">7</td><td >Pretzels</td><td >Steak</td><td >popcorn</td><td >Bbq chicken</td><td > </td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4 </a>
 
Upvote 0
that will little more complicated. you cannot use for J=1 to 7

you have to first find the uniuqe strings from columns B,C,D etc and loop it through each of the unique values. Post a small amount of data (sheet1)
 
Upvote 0
Thanks,

<TABLE style="MARGIN: auto auto auto 4.9pt; WIDTH: 414.95pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=553><TBODY><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap>service area<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=151 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap>Fries<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=151 noWrap>
one<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
two<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
Three<o:p></o:p>​


</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap>rings<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=151 noWrap>
one<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap>Pretzels<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=151 noWrap>
four<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
Five<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
Six<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
Seven<o:p></o:p>​


</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap>Steak<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=151 noWrap>
five<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
six<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
seven<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap>popcorn<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=151 noWrap>
three<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
four<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
five<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
six<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
seven<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 6"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap>Bbq chicken<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=151 noWrap>
two<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
seven<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 7"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap>Frites<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=151 noWrap>
three<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
four<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" width=64 noWrap>
five<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 8"><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=82 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=151 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 9"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" width=82 noWrap>
one <o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt" vAlign=bottom width=151 noWrap>Fries,,rings<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 10"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" width=82 noWrap>
two<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom width=151 noWrap>fries,bbq chicken<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 11"><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" width=82 noWrap>
three<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom width=151 noWrap>fries,popcorn,frites<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 12; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 61.55pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" width=82 noWrap>
four<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 113.4pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom width=151 noWrap>pretzels,popcorn,frites<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #c0c0c0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #efefef; HEIGHT: 13.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #3867a6 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap><o:p></o:p>

</TD></TR></TBODY></TABLE>
 
Upvote 0
park all the four macros in one module of the file

I have truncated your data for writing the macro purposes. the sheet1 will be like this

Excel Workbook
ABCDEFG
1service ara
2friesonetwothree
3ringsone
4pretzelsfourfivesixseven
5
Sheet1


the four macros are given below:

Code: 
Dim r As Range, un As Range, cun As Range, lastcell As Range, cfind As Range, cfind2 As Range
Dim area As String, number As String, add As String

Sub msinmacro()
unquenumbers
With Worksheets("sheet2")
Set r = Range(.Range("A1"), .Range("A1").End(xlDown))
Set un = .Range("A1").Offset(0, 1)
r.AdvancedFilter xlFilterCopy, , un, True
Set un = Range(un.Offset(1, 0), un.End(xlDown))
For Each cun In un
number = cun.Value
With Worksheets("sheet1")
Set cfind = .UsedRange.Cells.Find(what:=number, lookat:=xlWhole)
If cfind Is Nothing Then GoTo nextcun
add = cfind.Address
area = .Cells(cfind.Row, 1).Value
End With
.Cells(cun.Row, Columns.Count).End(xlToLeft).Offset(0, 1) = area
Do
With Worksheets("sheet1")
Set cfind = .Cells.FindNext(cfind)
If cfind Is Nothing Then Exit Do
If cfind.Address = add Then Exit Do
area = .Cells(cfind.Row, 1)
End With
.Cells(cun.Row, Columns.Count).End(xlToLeft).Offset(0, 1) = area
Loop
nextcun:
Next cun
.Cells(1, 1).EntireColumn.Delete
End With
converttonumbers
MsgBox "macro over"
End Sub


Code: 
Sub unquenumbers()
Dim j As Integer, r1 As Range, k As Integer
Worksheets("sheet1").Activate
Set lastcell = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell)
'MsgBox lastcell.Address
Set r = Range(Range("B1"), lastcell)
For j = 2 To lastcell.Column
Set un = Cells(Rows.Count, lastcell.Column + 5).End(xlUp).Offset(1, 0)
'MsgBox Range(Cells(2, j), Cells(lastcell.Row, j)).Address
Range(Cells(2, j), Cells(lastcell.Row, j)).Copy Cells(Rows.Count, lastcell.Column + 5).End(xlUp).Offset(1, 0)

Next j
Cells(1, lastcell.Column + 5) = "number"
Set r1 = Range(Cells(1, lastcell.Column + 5), Cells(Rows.Count, lastcell.Column + 5).End(xlUp))

For k = Cells(Rows.Count, lastcell.Column + 5).End(xlUp).Row To 2 Step -1
If Cells(k, lastcell.Column + 5) = "" Then Cells(k, lastcell.Column + 5).Delete Shift:=xlUp
Next k
Columns(Cells(1, lastcell.Column + 5).Column).Copy Worksheets("sheet2").Range("A1")
Columns(Cells(1, lastcell.Column + 5).Column).Delete
End Sub

Code: 
Sub converttonumbers()
 Worksheets("sheet2").Activate
 Range("B1").EntireColumn.Insert
 Range("B1") = "number1"
Set r = Range(Range("A2"), Range("A2").End(xlDown))
For Each cun In r
Select Case cun.Value
Case "one"
cun.Offset(0, 1) = 1
Case "two"
cun.Offset(0, 1) = 2
Case "three"
cun.Offset(0, 1) = 3
Case "four"
cun.Offset(0, 1) = 4
Case "five"
cun.Offset(0, 1) = 5
Case "six"
cun.Offset(0, 1) = 6
Case "seven"
cun.Offset(0, 1) = 7
End Select
Next cun

Range("A1").CurrentRegion.Sort key1:=Range("B1"), header:=xlYes

End Sub

Code: 
Sub undo()
Worksheets("sheet2").Cells.Clear
End Sub
Code:

then sheet 2 will be like this

Excel Workbook
ABCD
1numbernumber1
2one1friesrings
3two2fries
4three3fries
5four4pretzels
6five5pretzels
7six6pretzels
8seven7pretzels
Sheet2


if you want to test first run "undo" and then run "finalmacro" (only this macro even though all the macros are in the module)
 
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
622
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
VBA code clean up
Replies
9
Views
582
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V

Forum statistics

Threads
1,224,586
Messages
6,179,729
Members
452,939
Latest member
WCrawford

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