Ok....same issue I've just hit another roadblock. I need the same thing done however, I need the data placed in columns I:M in the next blank row. Currently to insert my data, this is what I use:
For the part you helped me with I did this:
So now instead of sheet named "Validation" and range AN3:AN7, I want to use:
sheet named "SkinData" and range I:M (it's 5 choices in the listbox) in the next blank row (as data is continually added to this spreadsheet.
Do I need to start a new thread for this? Thanks again!