Automatically insert row

  • Thread starter Thread starter desperate in MS
  • Start date Start date
D

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
 
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
 
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
 
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 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".
 
desperate said:
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".
Click to expand...
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.
 
Back
Top