Looking for some help on a small project of mine. VBA coding is not my thing and just started to learn now at a way later age than I'd like.

Backstory: I work in Business Management and look at a lot of project management finances. I see that it is pretty slow to add a new formula and then drag down the updated formula. I have been looking how to add a new row that is continuous on top of adding a Concatenate formula to provide a unique ID. I have done some research and found a file that will be able to add rows with a value of +1 for every row.

Goal(s):

Main Objective- If someone can help me to update the formula (Concatenate formula on column E), it is a straight copy and paste at this moment so it is not updating based on the new row. Can someone help me revise the code?

Secondary Objective- Also, it may be a reach but is there code out already that can ask for a text box of some sort to provide more than one new row with the appropriate formulas being copied as well?

Thank you for the help!

Please see the code below:

Please Login or Register  to view this content.