every time I go to enter data for a new row I have to tab along to nine spaces to enter data and so on. Is there any way I could enter data more quickly.
Your original question from post #1....so does the question for this thread apply to sheet #2 in your example file? Do you want to develop a userform with a combo box to select the name, ect. then put in in the next row of sheet 2?

The bottom line is that there probably isn't a faster way to do it but with a userform it would look a little cleaner.

About sheet #1.....I hope you don't plan on printing this or you will have to change the layout...at least on my printer.