I am attempting to put together a GUI for our employees to enter data into an excel database more effectively and efficently. Currently I have an activeX controller that shows a userform collects data and will enter that data to a second sheet perfectly as long as I specify the row it should go in. The data will always use the same columns, but I would love it if it would automatically find the last row of the database and then add the newly entered data into a new row after the current last row. I found an example online but I think that the syntax was all wrong and I cannot get it to work out.
Start Free Trial
