D
desperate in MS
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
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