![]() |
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