Hi!<o></o>
I have a table called “Notebook” and I need to copy and paste horizontally (just the values, maybe by using a paste special/value/transpose) some things of this table on the last blank line on the table “Notebook – Control” after pressing the button Goal Seek (Cell G66) which has a macro assigned to it (the copy and paste should be after this macro).<o></o>
Below is where the info on table “Notebook” should go on “Notebook – Control”<o></o>
<table class="MsoNormalTable" style="width: 214.6pt; margin-left: 3.5pt; border-collapse: collapse;" width="286" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15.75pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="124" nowrap="nowrap"> "Notebook"<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> "Notebook - Control"<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> A1<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> A<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> F66<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> B<o></o>
</td> </tr> <tr style="height: 15.75pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="124" nowrap="nowrap"> C75:C78<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> C:F<o></o>
</td> </tr> <tr style="height: 15.75pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="124" nowrap="nowrap"> F75<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> G<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> B8:B55<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> H:BC<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> D8:D55<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> BD:CY<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> E8:E55<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> CZ:EU<o></o>
</td> </tr> </tbody></table> <o></o>
This is the to files.
<a>http://www.4shared.com/file/goRLW6lN/Ad_Control.html</a>
I have a table called “Notebook” and I need to copy and paste horizontally (just the values, maybe by using a paste special/value/transpose) some things of this table on the last blank line on the table “Notebook – Control” after pressing the button Goal Seek (Cell G66) which has a macro assigned to it (the copy and paste should be after this macro).<o></o>
Below is where the info on table “Notebook” should go on “Notebook – Control”<o></o>
<table class="MsoNormalTable" style="width: 214.6pt; margin-left: 3.5pt; border-collapse: collapse;" width="286" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15.75pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="124" nowrap="nowrap"> "Notebook"<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> "Notebook - Control"<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> A1<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> A<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> F66<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> B<o></o>
</td> </tr> <tr style="height: 15.75pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="124" nowrap="nowrap"> C75:C78<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> C:F<o></o>
</td> </tr> <tr style="height: 15.75pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="124" nowrap="nowrap"> F75<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> G<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> B8:B55<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> H:BC<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> D8:D55<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> BD:CY<o></o>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 92.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="124" nowrap="nowrap"> E8:E55<o></o>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> CZ:EU<o></o>
</td> </tr> </tbody></table> <o></o>
This is the to files.
<a>http://www.4shared.com/file/goRLW6lN/Ad_Control.html</a>