VBA: Creat items and add to a database.

[qphale]

Hello,

I am trying to set up a macro that creates a new product into our product list and the adds these all to our main database which is where we store information on our technicians certification level on those products. So I have a list of technicians, products which also includes the default training level and request of 0 & 0, and then the overall database.

I have another sheet where people can enter in the new product franchise, name and ID and this will add it to the Product List and this is working perfectly well.

But now I need to create a new row in the main database for each technician on this new product, which currently is 99 rows.

The only issue I am having at the moment is that when it is pulling the names into the database this goes well but I need it to pull the last line from the products sheet (which will be the newest one) but it always goes for the one just above it. Is there anything wrong with this code?

Please Login or Register  to view this content.

[AliGW]

Welcome to the forum.

Code must be encased in code tags - please read the forum rules. I have done it for you this once.