Insert a specified number of rows dynamically

T

ttbbgg

Hi there.
I am dealing with a huge spreadsheet that will eventually be imported to a
database, however in the meantime i must only work with the spreadsheet.
I have to insert new records throughout the spreadsheet and must insert a
large number of new rows (sometimes 50 or more). Is there a macro or
something I can use that will ask me how many rows I want to insert without
me having to do it manually?
 
B

Beege

ttbbbgg,

If you select 50 rows at once, and "Insert", excel will place 50 rows above
your selection...

Beege
 
Top