insert rows in excel spreadsheet via macro

F

Floyd Elkins

I need to be able to insert a number into a column in an Excel Spreadsheet
and have that number of rows (copied from another row) entered following that
row.
 
F

Floyd Elkins

Thanks Bob - I really appreciate the prompt response! I need to be able to
go to a specific column (heading = Quantity). Based on the number entered, I
want to enter that number of rows immediately following this entry. I'm not
sure that a Macro is the right way to do this, and I can't find a command
that will do it. Any suggestions?

Thanks again,

Floyd
 
Top