Using a macro to copy and paste lists of data from one sheet to another

I am a new member and This is my first post WHO-HOO!!! had to get that out of the way. Now back to business I am fairly new to excel. I am trying to develop a macro that will grab data from one sheet and paste it to another sheet by clicking the entry in a combo box. I was partially successful with actualy getting the data from one sheet to another by developing a macro for each field and linking the field name to a field in the combo box. However, I want the macro to neatly place the data side by side.

Im not really Familiar with loops and If then else statements. But here is my thought process.
My thought process is
1)have a cell to put the first data in
2)check to see if any data is in the first row
3)check the next 9 rows to see if any data is in it
3a)If not then Paste the copied contents
3b) if it is then go to the first row of the next column and repeat step 3

Here is the code for the entries
Every time i try and run it i get a compile error
I think its because of my loops but im not sure

Please Login or Register  to view this content.

I uploaded the document because I know I probly did not do a good job explaining it. I labeled every thing in the comments as well

I need help...... when ever i get an error code it makes me sad
and I dont like to be sad. Thanks in advance for any help.

Johnnieboi

Maybe?

Please Login or Register  to view this content.