Adding a new row using a user form

Hi all!

I am very bad with excel and have been asked to do several projects for work so you will probably see me posting here a lot within the next few weeks! I created a user form (attached below) and I want users to be able to fill it out and when they click "insert new row" it will add a new row to my spreadsheet with the information they entered in the appropriate columns. I have also attached an example of my spreadsheet so you can see what that looks like. For now I just need the fields in the user form to be filled out so you can disregard any other information.Any help is greatly appreciated, much thanks!

Perhaps this will get you started.

BSB

You are amazing thank you so much!

Happy to help. Thanks for the rep point

Keep in mind bakerman2's wise words above regarding merged cells though. If this is just a way of recording data then they're fine, but if you ever need to create stats or do anything else even remotely fancy with this data then the merged cells will be the bane of your life.

BSB

Oh, and get rid of this line in the code:

Please Login or Register  to view this content.

It was there purely as a pointer for me to make sure it was looking at the correct row before pasting.

BSB