Automatically insert row

[desperate in MS]

I have a spreadsheet that I am needing to add 2 rows to after a certain
column has data entered.
Example:
A B C D
E F
1 XX XX XX Data column XX
XX
2 BLANK ROW
3 Here is where I want to add two rows , Once data has been entered into
d3 I
want two more rows at row 5 and so on and to end with a certain row
because this form has several different heading that this will be applied
to.
4 BLANK ROW
5 Two inserted rows

 

[Shane Devenshire]

Hi,

1. Suppose your data starts in A1. On row 2 of a blank column enter the
formula =IF(OR(A1="",A2=""),1,"") and copy it down.
2. Highlight the formula column and Press F5, Special, Formulas, and uncheck
all except Numbers, OK
3. Press Shift+Ctr++ (Control and the plus sign), choose Entire row

 

[desperate in MS]

Sorry I tried this from a blank worksheet and didn't have any luck.

I need the two rows to only be added and show up after new data is entered
in column "D". Data entered and "wala" actually 3 blank rows. And then this
would be repeated every time data is entered in column "D". "D" New data 3
rows, "D" new data 3 rows.

Thank you

 

[Shane Devenshire]

Well if you want it automatic, just move down two more rows. So if your data
looks like this

xxx
xxx last entry



Move down to here and enter the new data? Excel will not automatically add
blank rows to your spreadsheet unless you write VBA code. And there doesn't
seem to be a need for that here.

 

[desperate in MS]

if I need to write a macro to do this...I need one....just don't know
anything about macros and from what i've found that may work...I can't find
one that will tells me how to set it to add rows after data is entered
into..say "cell x" repeating this eveytime data is entered in "x".

 

[Lynz]

if I need to write a macro to do this...I need one....just don't know
anything about macros and from what i've found that may work...I can't find
one that will tells me how to set it to add rows after data is entered
into..say "cell x" repeating this eveytime data is entered in "x".

Are you adding new data to the top of your list in column D or to the
bottom of your list.
How does the data get into columns A, B and C?
You could use a user form to enter all of your data and insert blank rows.