Assigning a formula to a button

[gaudrco]

Hi,

I would like to be able to assign a command button to add anew column to the end of my table. Each new column added should appear to theright of the last new column added. The command button will be on theactivesheet but the table in which I am trying to add columns to will be onsheet “Competitor Overview Data”. The last row of the table is column S so thebutton when pressed would create a new column with the same formatting incolumn T, another press of the button would be column U.

Any ideas?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...column-end-table-post5329355.html#post5329355

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).