Insert Row and Formula

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
 
J

JBeaucaire

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.
 

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

Similar Threads

Insert Row also adds formulas and moves cursor 2
Insert formula and copy to a range of cells above 2
Insert Formula based in cell user clicks 2
Relative Formula References NOT changing After Insert From VB 5
Insert row and column headings 1
HOW: Click Formula Hyperlink To Trigger Macro 1
Breaking One Row into Multiple Rows using VBA Macro? 2
Row Insert, Add Text, Add Formula 1

Top