Create new Worksheets based on data on Main Worksheet

[mmcquinn2002]

Hi there,

I have a Workbook, which primarily has 3 worksheets, "Master", "Index" and "Data".
The "Data" worksheet contains data for individuals and is based on the "Master" worksheet.
The "Index" worksheet is the worksheet which contains the "Name" and "Id" of all the individual persons and has a hyperlink so that the user can go to the individual worksheet on clicking the link which is placed on the "Id"
However, since the number of people goes up every month, I would like to create a file
1. where the user just has to fill in the Name and Id of the person in the "Index" worksheet
2. on running a macro a separate worksheet with the "Id" as the name of the worksheet is created and
3. a hyperlink to the new worksheet is placed on the "Id" in the "Index" worksheet

Thanks in advance.

 

[Uhrlaff]

I can mention some basic steps that may help you.
1. turn on macro recording and simply click + sign to create a new worksheet. Then also right click worksheet and rename it to something. Turn off macro recording. now you have the basic code which you can use/modify later.
2. Next, google search how to dynamically change a worksheet name based on another cell value. (add this to you existing macro code)
3. Finally google search how to dynamically create a hyperlink in a sheet .... and add this to your macro code.
hopefully this helps. In terms of getting these 3 steps to connect/flow, you may need to create a function/formula in a certain cell in one of the sheets such as Index sheet.