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.
Bookmarks