Adding Preset Data to Template with Lists

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.