How to add a button that adds a row in multiple tables with formulas?

[gary_feesher]

Hello,

I recently downloaded a Waterfall Chart Generator (here is the sample file I am using: Waterfall Generator Sample XLSX) and I would like to make the tables more dynamic. I would like one button that adds a new column to insert data in the table to the right. And with the same button, a new row added in the table underneath the chart which fills in based on the data from the table on the right. I am having a lot of trouble figuring out how to do this with one button. Any help is greatly appreciated!

In the table to the right, I would like to:

• Be able to add a new Part

In the table below:

• Add a new row with the same name from the item added in the first table.
• And also have the proper formulas automatically copied down.

photo.png

[Philb1]

Hi Gary
I gave you an answer on your other post
http://www.excelforum.com/showthread...60#post4405260