Macro/VBA to keep formula in newly inserted row

[Antligen]

Ok, here goes:

Here attached is my sample workbook:

Attachment 310920

My button inserts a new row into the table.

What I want is that everytime a new blank row is created, the formula in the Days in Situ column is there as well (but obviously the cells update depending with which ever row it's in.. eg below formula is row 10.).

This is the formula:

Please Login or Register  to view this content.

I've tried recording a macro that inserts a new row, copies and then pastes the formula, then types in the cells that it applies to. BUT, after a couple of clicks on the button the formulas dissappear. That option doesn't work.

Perhaps it needs some kind of VBA code to ensure that the formula is there in column I....

Can this be done? Major impressed if someone manages to perminently fix this problem!

[Pete_UK]

I can't download your attachment.

If you set the data up in an Excel Table (put the cursor in the table then click Insert | Table), then Excel will automatically copy formulae into newly-inserted rows and if you add data to the bottom of the table.

Hope this helps.

Pete

[Antligen]

Is this better??

[Antligen]

@Pete_UK

I'm using excel 2010. I will try attaching another to see if it's more compatible.

Try this:TasterofwhatIwant(1).xls

Are you able to open it now?

[Pete_UK]

Yes, I opened it. Just do what I said before.

Pete