Insert a specified number of rows dynamically
 

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?

Insert a specified number of rows dynamically
 

ttbbbgg,

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

Beege

"ttbbgg" wrote in message
...
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?

Insert a specified number of rows dynamically
 

BAH! It can't really be that simple....good god I'm an idiot.
Thanks
:(

"Beege" wrote:

ttbbbgg,

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

Beege

"ttbbgg" wrote in message
...
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?