highlight the entire row where he wants to insert a row, right click then
insert row
then he can hit ctrl Y to insert more rows at that location if needed
then he can highlight the new rows with the old row above it then hit ctrl d

That will copy formulas down.

"jgray" wrote:

hey guys,

I'm trying to create a macro to streamline a process for one of our factory
guys. Right now, I'm going down and manually inserting rows into a database
and then dragging the needed formulas and information from the rows above
down. What I'm trying to do is make it so he can place his cursor, hit the
macro key stroke and have that done for him. When I record the macro, I
think I am making an absolute cell reference, because when I run the macro it
will only instert where I initially inserted the row. How do I create the
macro so he can select where he wants it and then have the row inserted and
formulas dropped down for him?

Thanks in advance for all your help!

James