VBA or formula for adding row with formulas in it

[JacobTheKid]

I need to automatically add a new row every time a table is filled, and that new row needs to have formulas in it's cell. I can't figure out how to do this.
Here is the link to a copy of the file, I would need it on the Bottom of sheet 2 (which references the sheet "Form" in the formula i want to copy)

hermonnet-my.sharepoint.com/:x:/g/personal/lana417_hermon_net/ESGDFWEtKxBKkWj2AtncpEsBJaOSBAzKjW_59JqYUm3KeA?e=X5Aowx

[Bernie Deitrick]

I did not open your workbook.

Option 1)

Use a formula like

=IF(Form!$A2<>"",Form!A2,"")

and copy across to create your table, changing the formula as needed. Then copy down to make many more rows that you need, and as your Form sheet is filled, the data will be carried over.

Option 2)

Change event macro:


1) Copy this code.
2) Right-Click the sheet tab of "Form"
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed - this assumes that the sheets have the same number of rows

Please Login or Register  to view this content.