|I would like to have a macro create a new worksheet naming it the value of the cell in the second row when I click on the 5th cell in the same row.|
Here is an example of my data.
A B C D E
(Blank) Asset ID Service Class Unit # Details
L01L22A26 Class 1 01 Details
L03L01A36 Class 1 03 Details
L03L06A08 Class 1 03 Details
L03L07A44 Class 1 03 Details
L03L07A45 Class 1 03 Details
L05L01A01 Class 1 05 Details
So, when I would click on Details in the last column, a new worksheet would populate named L01L22A26. Then I would like to have the data in the column B and C of that row, copied over to the new worksheet at Range D2:E2.
I have thousands of rows of data and only want them to create a new sheet when clicked.
Any help is greatly appreciated!! Thank you in advance for your time.