I am trying to create a "form" where the user enters information and hits the "Add" button which is linked to a macro that adds the data to the next free row at the end of the current database.

However, one part of what the user enters will be transferred to a certain cell in the database, which is based on what is entered in another cell in the form. However, I do not know how to create a "conditional" copy/paste statement. Here is my attempt - obviously the .Paste isn't working for me but it gives you an idea of what I'm going for:

Please Login or Register  to view this content.

Also, LastRow is a variable that is functioning fine. It's defined to go to the next line after the last line in the database:

Please Login or Register  to view this content.
Any thoughts on I can accomplish this?

Thanks