Select row, move data to specific line in new worksheet

This is probably simple but I can't get my head around it today.

I want to be able to select a row in a worksheet, activate a button, and generate a new worksheet with the data in just that row going to new rows and columns pre selected in the new sheet.

IE, row 4 column 5 gets placed in row 2, column 3 on new sheet, row 4 column 6 gets placed in row 3 column 3 on new sheet, etc.

An example might be a row that contains a name and address along with other information. The name and address would be placed in different rows (maybe same column, maybe not) in the new sheet along with other information as needed.

All the columns in the data sheet contain the same kind of data in every row so all I need to do is select the row and identify (in the VB) which columns get copied to the new row and where.

Its sounds to me like you are just trying to copy a row in one sheet and transpose it down a column in another.

- Does the new worksheet already exist or do we need to create new one? Does it need to have a name?

- You want to manually select the row, click a button, then manually select a column in the new sheet and have it pasted (transposed) there?

- Is there anyway you could attach a sample worksheet showing before and after?

I'm still working with this to see for sure what I want to wind up with, but I think if you look at the attached data sheet and envision that row 4 gets selected and a button activated, a workbook is created and named after one of the cells and the 1st created sheet is placed in the new workbook. If row 5 is selected then same thing but the info on the second sheet shows up.

It's pretty easy to simply copy cells from one sheet to another and move them around using the same cells every time, I just haven't figured out how to use the highlighted row to select the data that gets copied and moved.