| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically insert page break every 6 rows in excel doc | Excel Discussion (Misc queries) | |||
| Insert duplicate rows based on numeric value in column | Excel Discussion (Misc queries) | |||
| Can you automatically insert next sequential number in an excel fo | Excel Discussion (Misc queries) | |||
| can't insert more rows even though not at max rows | Excel Worksheet Functions | |||
| Auto Insert of Rows | Excel Worksheet Functions | |||
Hybrid Mode
