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.