Macro to copy formulas down based on row count from another sheet

Hello,

I'm very good with spreadsheets, but a major noob when it comes to VBA. I need to tweek a spreadsheet so that I can hand it off to someone who is a little less experienced in excel. One of the enhancements that I would like to do is create a macro to copy a row of formulas down. The formulas are on Sheet 2 and they are linking to an essbase retrieve on Sheet 1. The rowcount on Sheet 1 is variable. I need a macro that will look at the number of rows on sheet 1 and copy the formula down (on sheet 2) the appropriate number of rows. I've attached a simple example.

Again, I'm very new to VBA so everything still looks like Greek to me. I'll try to not ask too many dumb questions.

Thanks!
KD

Awesome!!! That worked! And the really cool thing is that I was pretty close to getting it right on my own so maybe that means I can learn this stuff afterall!

Thanks again!

KD