Macro to create new worksheet based on cell clicked

February 24, 2012 at 09:30:45
Specs: Windows 7
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.


See More: Macro to create new worksheet based on cell clicked

Report •

#1
February 24, 2012 at 12:58:07
re: ...create a new worksheet naming it the value of the cell in the second row...

The second row? If you are always going to be copying data from the second row, why does it matter that you have "thousands of rows of data"?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 24, 2012 at 13:34:21
I'm sorry, I meant second column. Column B, Each Asset ID.

Report •
Related Solutions


Ask Question