macro that puts a formula in a group of cells then goes and values those cells

Hi, this has been a big mess for me to try to macro record in the file I am working in. What I am trying to do is tell excel to copy a bunch of lines down into another section and then value that section so it does not change.
Every month we need to look at variances for our numbers, I want to push a button once a month so it takes what I had last month and pushes it down to prior before I build current. Then a subtraction formula shows my variances.

A picture is worth a thousand words so I included this file...

Using a command button from the Control Toolbox you could use the following.

Please Login or Register  to view this content.

this sub will look for all rows containing current and copy the row to the table starting in cell 28 in your case. But you could put the table where ever you want.

Hope thats what you want:

Please Login or Register  to view this content.

Wow, that is really slick Reafidy, really slick. I got it to work in my file, but can I please have a little more help?

I added a bit of a twist. The file I am using has a big gap in the middle between 2008 and 2009, where other formulas, operations and inputs are that I don't want copied below. Is there a way to write this code so it skips the middle? Also the file I am working on has several sheets, but only 7 need this macro, and all 7 have pretty much the same format, is there an easy way to make it so when I push my button it does all 7 sheets with one click.

You rock in every way thanks for your help!!!

Oops, it did not add my file...

assuming your tables are in line:

Please Login or Register  to view this content.

yes that could work but this might be easier:

Please Login or Register  to view this content.