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
|