<div class="quoteheader"><div class="topslice_quote"><a href="https://elliquiy.com/forums/index.php?topic=148593.msg7204177#msg7204177">Quote from: Chrystal on 10-11-2012, 22:41:21</a></div></div><blockquote class="bbc_standard_quote">A2 set to 12. B2 set to 38, C2 set to =A2+C2<br/><br/>Record the following macro: Select cell C2. &lt;CTRL&gt;+C. Right-click in C2 (or click the "Paste" menu). Select "Paste Special", then "Values". Stop Recording.<br/><br/>Assign this Macro a hot-key such as &lt;CTRL&gt;+&lt;Shift&gt;+G.<br/><br/>The macro code is:<br/><br/><div class="codeheader">Code: <a class="codeoperation" href="javascript:void(0);" onclick="return smfSelectText(this);">[Select]</a></div><pre style="margin: 0; padding: 0;"><code class="bbc_code">Sub Macro2()<br/>'<br/>' Macro2 Macro<br/>'<br/>' Keyboard Shortcut: Ctrl+Shift+G<br/>'<br/>    Range("C2").Select<br/>    Selection.Copy<br/>    Range("B2").Select<br/>    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _<br/>        :=False, Transpose:=False<br/>End Sub<br/></code></pre><br/><table class="bbc_table"><tbody><tr><td>Action</td><td>A2</td><td>B2</td><td>C2</td></tr><tr><td>Initial Values</td><td>12</td><td>38</td><td>50</td></tr><tr><td>Record macro</td><td>12</td><td>50</td><td>62</td></tr><tr><td>Change A2</td><td>22</td><td>50</td><td>72</td></tr><tr><td>Run Macro</td><td>22</td><td>72</td><td>94</td></tr><tr><td>Change A2</td><td>32</td><td>72</td><td>104</td></tr><tr><td>Run Macro</td><td>32</td><td>104</td><td>136</td></tr><tr><td>Change A2</td><td>42</td><td>104</td><td>146</td></tr></tbody></table><br/>And so on... Run the macro each time before you change A2.<br/><br/>I've tried it, it works.<br/></blockquote><div class="quotefooter"><div class="botslice_quote"></div></div><br/><br/><br/>Damn, that was sexy.<br/><br/>I mean, nicely done, Chrystal.<br/><br/>Blinkin, just so you know, Chrystal's macro is copying the C2 total value to B2.  If B2 is supposed to be a constant or if it's something you would also want to change like A2, this particular macro won't work for you.<br/><br/>Would you be willing to explain for what purpose you are trying to do this?  What are A2 and B2 and C2 supposed to represent?<br/><br/>How often will you change A2?<br/><br/>Will you change B2?  If so, how often?<br/><br/>If it's not that often, try this.<br/><br/>In A1, put "=sum(a2:a100)"<br/>In B1, put "=sum(b2:b100)"<br/>In C1, put "=a1+b1"<br/><br/>Then keep adding values to the bottom of columns A and B.<br/><br/>Maybe a macro could "push" the values down so you can put your new values near the top of the list.<br/><br/>The problem is that your old total value or all your old A1 values have to be somewhere in the worksheet if you want to use it in any calculation.<br/><br/>Chrystal's macro puts your old total value in the B1 cell, making B1 useless for anything else.<br/><br/>My idea keeps your old A1 values on the sheet but you have to put your new A1 values somewhere other than A1.<br/>