Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Inserting Rows into a worksheet

I need to be able to enter a given number into a column in Excel and have
that number of rows added in the next row (copied from another row).
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default Inserting Rows into a worksheet

David McRitchie has a nice macro that asks how many rows should be inserted and
even copies the formulas down to those new rows.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Floyd Elkins wrote:

I need to be able to enter a given number into a column in Excel and have
that number of rows added in the next row (copied from another row).


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet protection, going beyond inserting rows Wh0079 Excel Discussion (Misc queries) 6 September 27th 08 12:22 AM
Inserting Multiple Rows Throughout Worksheet Tabby Excel Worksheet Functions 1 March 12th 08 09:21 PM
Inserting rows in worksheet P.hamsa Excel Discussion (Misc queries) 4 August 6th 07 09:46 AM
INSERTING ROWS IN PROTECTED WORKSHEET TLAngelo Excel Discussion (Misc queries) 0 July 18th 06 06:18 PM
Inserting fillable Rows within a Protected Worksheet dtmd Excel Worksheet Functions 0 November 18th 05 06:37 PM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"