Hello,
Hopefully my problem is simple for all of you Excel Wizards out there. I have an Excel sheet with multiple worksheets. Each worksheet has it's own data and that data is related to each of the other data in the other worksheets. Anyway, I have a form that allows you to go to the main worksheet and select the row of data you want to compare with the some of the other data. In the row of data there are some cells that are not important. Here is what I have so far in terms of code:
I want to be able to selectively pick a cell from the highlighted row, generate a new worksheet and copy that cell on to the new worksheet.
Any help would be greatly appreciated, especially on how to selectively pick a cell from the highlighted row.
Thank you all in advance!
Hopefully my problem is simple for all of you Excel Wizards out there. I have an Excel sheet with multiple worksheets. Each worksheet has it's own data and that data is related to each of the other data in the other worksheets. Anyway, I have a form that allows you to go to the main worksheet and select the row of data you want to compare with the some of the other data. In the row of data there are some cells that are not important. Here is what I have so far in terms of code:
HTML:
' Used for the "Exit" ButtonPrivate Sub exitbutton_Click() Unload MeEnd Sub
' Used for the "Generate" Button
Private Sub Generate_Click()' Copies the selected reference dataDim reference As RangeSet reference = Range(Selection.Address)reference.Rows().Selecta = reference(Cells(1, 1))
End Sub
I want to be able to selectively pick a cell from the highlighted row, generate a new worksheet and copy that cell on to the new worksheet.
Any help would be greatly appreciated, especially on how to selectively pick a cell from the highlighted row.
Thank you all in advance!