mmcquinn2002
New Member
- Joined
- Apr 5, 2020
- Messages
- 13
- Office Version
- 2016
- Platform
- Windows
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.
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.