1) You want this to happen automatically when you add a row to a worksheet, or you want to add a bunch of rows and then run the program when you're through making the changes? The first is more complicated, but I'm pretty sure it can be done. The second is easier, I think.

2) How much do you know about writing VBA already? Because I can teach you how, but if you just want someone to write it for you, you'll have to wait for someone else. I'm a teach-a-man-to-fish kind of guy, myself.