Also, any thoughts on how to control where the UserForm data is transfer to. I would like the data selected in the UserForm to be transferred on Sheet 1 starting in cells B6:G6 (under the appropriate columns), then each new data entry should transfer to the next empty row below (i.e. $B7:$G7, $B8:$G8, and so on).
Help here would also be greatly appreciated!
Bookmarks