Control Table

rwfighera

New Member
Joined
Dec 19, 2009
Messages
19
Hi!<o:p></o:p>

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:p></o:p>
Below is where the info on table “Notebook” should go on “Notebook – Control”<o:p></o:p>
<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:p></o:p>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> "Notebook - Control"<o:p></o:p>
</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:p></o:p>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> A<o:p></o:p>
</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:p></o:p>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> B<o:p></o:p>
</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:p></o:p>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> C:F<o:p></o:p>
</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:p></o:p>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15.75pt;" valign="bottom" width="162" nowrap="nowrap"> G<o:p></o:p>
</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:p></o:p>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> H:BC<o:p></o:p>
</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:p></o:p>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> BD:CY<o:p></o:p>
</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:p></o:p>
</td> <td style="width: 121.8pt; padding: 0cm 3.5pt; height: 15pt;" valign="bottom" width="162" nowrap="nowrap"> CZ:EU<o:p></o:p>
</td> </tr> </tbody></table> <o:p></o:p>

This is the to files.

<a>http://www.4shared.com/file/goRLW6lN/Ad_Control.html</a>
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,228
Messages
5,509,926
Members
408,765
Latest member
johncox3

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top