Add Row at the end of Sheet VBA

[Sgtvelez]

Looking for assistance with writing code to do a few things at first.

Need to understand code to insert a row in an excel workbook at the end of the record. (As in Access, when you tab past the last field it creates a new record)

[TMS]

Welcome to the forum. Unfortunately, your first post does not comply with the forum rules and you will need to change the title ... before it attracts the attention of the moderators.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[TMS]

Select your data from row 5 to row 102 and then Insert Table. Confirm your data has headers.

You should then find that a) you don't need to format all the "empty" rows and b) when you type in a cell on the next row after the table it will copy the formatting and formulae down. Ir won't insert rows, AFAIK.

Not a good idea to have your analysis under the input/raw data area ... you need to move that to a separate sheet.

Regards, TMS