Excel UserForm Transfer of data to Columns

**rudevincy** · 12-19-2012, 03:30 PM

I have managed to put together some code that will based on the selection for the user form transfer the data to a sheet.

However, I would like the data to transfer the data and move to the next column, so if the user selects the button add the data is added to a column and each time the add button is selected then it will move to the next column and paste the data. Right now it just over writes the existing data in the column

Here is the code I have so far.... just need to to get to move to the next column.

Please Login or Register  to view this content.

**davesexcel** · 12-19-2012, 11:27 PM

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

**rudevincy** · 12-20-2012, 12:31 AM

I have tried many times to upload my file however I keep getting an error.... I will continue to try as I truely need help!

**rudevincy** · 12-20-2012, 12:43 AM

Create Segment.xlsm

Attached is my sample file when the user clicks the button a form will appear and the user can create by selecting the names for a segment, each time the user clicks add it should transfer the selection to the sheet and move to the next column so that the user if need be can continue creating segments without over riding the one created.