ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatically adding row when data is entered (https://www.excelbanter.com/excel-programming/423745-automatically-adding-row-when-data-entered.html)

desperate in MS

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


All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com