I want to make a blank "form" where the user will use Sheet1 to enter in some data in two or more cells. For example, A1, A2 and A3. I would like for a VBA macro to cut this data from Sheet1, concatenate it together as a string and paste it into Sheet2 in the same column (Column A for example) with the next empty cell.
I think the above code is a starting point but I keep getting an error from using this code. I pulled this from someone else who had a similar goal a while back... Not sure if it makes a difference but I use Excel 2010.
Bookmarks