Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Automatically adding row when data is entered

I have a spreadsheet that I am needing to add 2 rows each time data is
entered into column "D".

Example:
A B C D
1 XX XX XX Data column
2 BLANK ROW
3 Here is where I want to have something that will automatically add three
rows (3,4,5), Once data has been entered into "D1"
4 BLANK ROW
5 Same as #3 I want three more rows (6,7,8) when data is entered in "D3"
and so on.
6 BLANK ROW
7 Again, same as #3&35 I want three more rows (8,9,10) when data is
entered in "D5" and so on. Down to around a possibility of 30 rows.

This spreasheet also have several different "heading" types..such as..
Topic
(which will have the above data & rows under it) then...
Topic 2
(and this will also have data and the need to insert a number of rows)
Topic 3...and so on

I hope someone can help me....And I don't follow Macros very well...may have
to really spell it out for me....thanks
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
Adding rows once data is entered desperate in MS Excel Discussion (Misc queries) 1 February 9th 09 06:57 PM
data from one workbook automatically entered into another workboo. cfrt Excel Discussion (Misc queries) 1 September 10th 08 01:11 AM
Data Range updating automatically as new data is entered mgnrke28 Charts and Charting in Excel 1 July 10th 08 02:02 PM
How do I get data automatically entered into a cell? rldjda Excel Worksheet Functions 1 January 18th 07 07:19 AM
How do I lock a cell automatically after it has data entered. Dandy Excel Discussion (Misc queries) 0 March 30th 06 12:39 PM


All times are GMT +1. The time now is 01:43 AM.

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

About Us

"It's about Microsoft Excel"