Automatically insert row
 

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

Automatically insert row
 

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
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

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

Automatically insert row
 

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" wrote:

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
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

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

Automatically insert row
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

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" wrote:

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
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

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

Automatically insert row
 

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".

Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

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" wrote:

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
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

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

Automatically insert row
 

desperate in MS wrote:
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".

Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

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" wrote:

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
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

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


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.