Within table insert new row above but formulas don't copy over?

[atearth]

I have a table with formulas.

I insert new row above but some formulas copy over and some don't.

Any idea how to solve this issue?

I have added the attached file.

Basically I try inserting a new row but the formulas don't copy over. Mainly in column C, D and E

[oeldere]

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[atearth]

I have now uploaded the file

[oeldere]

And in which sheet and which row did you enter a new row, where the formula is not added?

[atearth]

sheet 3, pick any row within the table and insert a new row.

Formula will be missing from the newly created row within column C, D & E

[oeldere]

Yes I understand your problem, but have no solution for that.

I tried google to find a treat on that issue, but found none (but that can also be caused by my google skills).

Of course you can copy the formula from an old range to the new range (or use a macro for that).

But that would not be neccesary.

[peterrc]

Hi atearth,

I have added a Command Button "Insert Row", just follow the "instruction" - see attached.
To insert a single Row put 1 (one) in the "box".
Once you have inserted the new Row(s) either delete the duplicated name(s) or select new name(s) from the drop-down list.
Will this work for you?

Regards

peterrc