I want to create a userform that will have two columns of textboxes (35
in each column). one column of textboxes I will input info into and the
other textbox column I want the info to auto enter from a cell in my
spreadsheet.

example:

Userform 1
Column 1_____________________________Column 2
get info from cell Activeworksheet B10 ___user entered data
get info from cell Activeworksheet B11 ___user entered data
get info from cell Activeworksheet B12 ___user entered data
......and so on.

CommandButton 1 ________________CmdBtn 2
get client info from cell _____________dump column 2 in to worksheet next column 1 cells 'B10' and so on

I have no idea how to make this userform could someone please show me how to do this. Or point me to a website that will show me how to do this.

Please tell me step by step...I know that this is simple for most of you.