How to take new data from a UserForm and sort?

[jsprott]

OK, I've got a database with a UserForm for entering the data. The top selection on the UserForm is a ComboBox, and the ComboBox has a list of #'s that are in the database. When one is selected the change imports the rest of the data into the UserForm. From there you can change (or not) any data and click the Done button. The problem is, that if the # is not in the database and you fill in the feilds as needed, the Done button will do nothing.

I've added (but may not need) another button called NEW. I've been able to input the new data with this button, except that the data needs to be "sorted" or "inserted" into the data form correctly.

Any help?

[Leith Ross]

Hello jsprot,

Write a macro to transfer the data from the UserForm to another worksheet and also copy the database to the same sheet. You can then use Excel's built-in sorting methods, which you can call from VBA, to sort the data before copying it back to the database.

[jsprott]

Hello, thanks for the quick reply, but I've done that in the past.

Here is an attachment that may help.

The database needs to be sorted into the zones where needed.

Thanks.