Very nice Logit, but I still need to save the results to somewhere else (for job 1 & 2).
Then if changes are made I need to import them back so they are viewed in the user form boxes where I can 'say' change Rafters to Trusses then save it to where it was imported from.
I usually use Sheet1 as my data holder.

I do appreciate what you are showing me and think I should follow your advice in hard coding possible selections for ComboBoxes in the Future.