In this spreadsheet application I am trying to build, the user will enter a row of information for a specific time period. In a macro called from a button on this sheet, I want to take values from whichever row the user selected before clicking the button, and transfer it to a second sheet which for this case is a vertical column. The horizontal to vertical thing seems pretty straighforward, the problem is telling which row the user selected to start with. Any help or hints would be greatly appreciated.

Thanks,
Randy