software

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?

ttbbbgg,

If you select 50 rows at once, and quot;Insertquot;, excel will place 50 rows above
your selection...

Beege

quot;ttbbggquot; gt; wrote in message
...
gt; Hi there.
gt; I am dealing with a huge spreadsheet that will eventually be imported to a
gt; database, however in the meantime i must only work with the spreadsheet.
gt; I have to insert new records throughout the spreadsheet and must insert a
gt; large number of new rows (sometimes 50 or more). Is there a macro or
gt; something I can use that will ask me how many rows I want to insert
gt; without
gt; me having to do it manually?
BAH! It can't really be that simple....good god I'm an idiot.
Thanksquot;Beegequot; wrote:

gt; ttbbbgg,
gt;
gt; If you select 50 rows at once, and quot;Insertquot;, excel will place 50 rows above
gt; your selection...
gt;
gt; Beege
gt;
gt; quot;ttbbggquot; gt; wrote in message
gt; ...
gt; gt; Hi there.
gt; gt; I am dealing with a huge spreadsheet that will eventually be imported to a
gt; gt; database, however in the meantime i must only work with the spreadsheet.
gt; gt; I have to insert new records throughout the spreadsheet and must insert a
gt; gt; large number of new rows (sometimes 50 or more). Is there a macro or
gt; gt; something I can use that will ask me how many rows I want to insert
gt; gt; without
gt; gt; me having to do it manually?
gt;
gt;
gt;