Automatically insert row

  • Thread starter desperate in MS
  • 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
 
S

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
 
D

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
 
S

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

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

Lynz

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top