Thread: Adding Preset Data to Template with Lists

Your code does fill out both columns as far as I can see?
It also checks column A to find the next row to put data in. If column A is not filled out, it will overwrite the data.

Well, can I change it to where it isn't just checking column A, but all columns for any data at all? Column A may not always have data in it at the time this userform will be run.

Also, I don't know how it is letting you add data to both Mfg ID and Mfg Name, and Brand ID and Brand Name, mine is only putting the ID's on the sheet and not the names.

Mine wasn't adding names - I thought you were saying that yours was only adding one of the IDs. Try this version - I've added a new function to get the last used row in the sheet and code to add the names from the comboboxes too.