Edit VBA Code Which Automatically Creates New Worksheet

Hi,

I am having issues with the following code:-

Please Login or Register  to view this content.

It works in part but I have issues with the following:-

1) It creates a new worksheet when I enter a value into the K12:K44 range on my master worksheet which is correct, but I need it to only create a new worksheet if the value is "Yes". The values entered into this range will be either "Yes" or No".
2) When it creates the new worksheet, it names the worksheet as the cell value from the range K12:K44. I need it to name the worksheet as the cell value from the corresponding row of range A12:A44. These values will be numerical.
3) It does create a hyperlink to the newly created worksheet, but the hyperlink needs to be applied to the cell from range A12:A44. At the moment it creates it in the cells of range K12:K44.

There is also 1 other minor issue.

The master worksheet has a summary of information which currently runs from rows 12 to 44. If I were to insert 2 additional rows within 12 to 44, I now have information that covers rows 12 to 46, but the range in VBA code is still row 12 to 44. Is there a way so have the code update the range if additional rows are inserted?

I have attached the workbook and hopefully everything above makes sense.

Many thanks in advance.

Give this a try and let us know if it does what you need.

Please Login or Register  to view this content.

BSB