D
dipsy
I have a workbook with 2 sheets - Sheet 1 is summary and
Sheet 2 is detail. In Sheet 1 I have created hyperlinks
to sheet 2.
So Sheet 1 - Business Name
Sheet 2 - Project Detail for each Business
The hyperlink is from Sheet 1 Business Name to Sheet 2
Business Unit Name and then the project details.
Everytime there is a new project the hyperlink gets broken.
Is there a way to automatically update the hyperlink in
sheet 1 to the new line.
Thanks in advance.
Sheet 2 is detail. In Sheet 1 I have created hyperlinks
to sheet 2.
So Sheet 1 - Business Name
Sheet 2 - Project Detail for each Business
The hyperlink is from Sheet 1 Business Name to Sheet 2
Business Unit Name and then the project details.
Everytime there is a new project the hyperlink gets broken.
Is there a way to automatically update the hyperlink in
sheet 1 to the new line.
Thanks in advance.