Move data in 3 cells/3 Columns to adjacent columns with Full Year monthly headers based on short date in column AA
<p>I have an existing macro that populates expense data into three adjacent cells in columns K-M (for ~300 rows) and I want to copy the data in these cells (same order) and paste special values based on the month value of a short date that is located in column AA.  The copied data needs to be pasted into the same row as source, but columns N-Y (headers = Jan, Feb, March, Apr...Dec).  Is there code to do this?</p>

<p><a href="http://i.stack.imgur.com/ZtoiL.png" rel="nofollow">example below</a></p>

<pre><code>Column| K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA |
Header| $ | $ | $ | J | F | M | A | M | J | J | A | S | O | N | D |FY |Date|
Row 3 |978|540|395|--&gt;|--&gt;|978|540|395|   |   |   |   |   |   |  |1913|5/11|
Row 4 |841|779|120|--&gt;|--&gt;|--&gt;|--&gt;|841|779|120|   |   |   |   |  |1740|7/24|
Row 5 |682|557| 55|--&gt;|--&gt;|--&gt;|--&gt;|--&gt;|--&gt;|682|557| 55|   |   |  |1294|9/18|                    '   Row 6 |985|883|578|--&gt;|--&gt;|--&gt;|--&gt;|--&gt;|--&gt;|--&gt;|--&gt;|-&gt;|985|883|578|2446|12/2|
</code></pre>