Insert Row and Formula

  • Thread starter Thread starter Dav1d
  • Start date Start date
D

Dav1d

I tried really hard to find this myself, but failed.

I have a worksheet containing 5 separate blocks of data (own headings,
column titles, etc); some of the cells contain formula.

I want a macro that wll insert a row when a block is filled ( in column "H"
actually), copying the formula as well. This needs to work on all the blocks
when the same condition is met.

Can anyone help me?

Many thanks
David
 
You should try turning on the "LIST" feature for each of your datasets. Put
your cursor in the data and press CTRL-L to activate the "List" wizard.

Once it is on, you'll see an "expansion row" offered at the bottom of your
data. If you type ANYTHING in that row, Excel will expand the "LIST" to
encompass this row permanently and it will copy any formulas from the row
above into that row as well as formatting.

This will also work if you click on a row in the middle of the data and
select "insert row". The "List" will always make sure new rows have the
needed and formatting and formulas.
 
Back
Top