Adding rows and keeping formulas

**jesusrms** · 12-16-2014, 06:21 PM

Hello All,

I tried to do this myself but failed miserably. I would like to add a button (Additional Piece) that can add a row just before total row. This row should copy formulas from column B and I:R; columns C:H are free fill. Of course every time I add a column the row with totals should take it into account. Can someone please help ?Packing List Imperial & Metric.xlsm

**mehmetcik** · 12-16-2014, 06:53 PM

Please Login or Register  to view this content.

**jesusrms** · 12-16-2014, 07:14 PM

Mehmetcik, you are the man. thank you very much.

**MHJEDA** · 12-01-2015, 08:48 AM

Mehmetcik your solution is perfect for what I need.
Can you please write a copy for the attached sheet? I want to add a button for the monthly sheets to add a row just above the total sheets keeping the formulas from the row above.
Thank you in advance for your help.

**alansidman** · 12-01-2015, 08:50 AM

@MHJEDA
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.