Add a button to insert new line....

**DMA-Pacific** · 05-12-2012, 07:50 AM

I would like to add a button or I guess it would be called a macro to lines 17, 24, and 43. I want it so that when you click the new line macro it inserts a blank line with the data validation and conditional formatting that the columns currently have. I've looked everywhere and everything I've looked at requires more "programming" than I feel comfortable with. Also, if you look at the spreadsheet and have any ideas to make it look more corporate or cleaner please let me know. I really appreciate the help on here and look forward to seeing how someone can do this.

Thanks.

Marty

**royUK** · 05-12-2012, 08:59 AM

If you used Excel's Table feature then you wouldn't need any button or code. In addition the inbuilt formatting is much more professional looking

**DMA-Pacific** · 05-13-2012, 08:58 AM

Boy, I feel really stupid.. after reading this tutorial I don't understand how this would solve my problem.

**BarryTSL** · 05-13-2012, 11:15 AM

See attached sheet. The macro gets the row required from the active cell position, so if you want a row in 14 click on A14 first then click the "Add Line" button.

**royUK** · 05-13-2012, 02:06 PM

With a table a new line is added automatically with formulas & formatting. You need to tidy the sheet - make sure that the table is distinct by adding some rows
I've done the first table, as you add data to the column A the table expands.

Start typing in A23 & watch the screen