@blueice_haller
Better late than never :). Was not present in 2019 but this is only one side of the coin.
The fact that nobody replied usually means that there was no precise information from the user.
Information on the Excel version, operating system, storage medium, file extension, step-by-step explanation/instructions, etc.
The more information the user provides on the way to his request, the faster and more accurately he can expect an answer. Please note that this is a forum of users and for users, while provided as the ultimate patron by Microsoft and deemed to be the last instance, users ultimately make up the forum. Help and be helped.
To keep it short, this is usually the reason that no one answers some questions/concerns/problems. Too little information and not enough time for other users to interact with the user to understand the problem. That is why this link was created at the very beginning of the forum.
Pinned Posts --> Welcome to your Excel discussion space!
Here is a small solution proposal:
To insert a link to a cell in another worksheet in Excel Office 365, you can use the "Insert Hyperlink" feature. Here is how you can do it:
- Open the worksheet where you want to insert the link (Worksheet A, in your case).
- Select the cell where you want the link to appear.
- Go to the "Insert" tab in the Excel ribbon.
- Click on the "Link" button (it might be labeled as "Hyperlink" or "Link to").
- In the "Insert Hyperlink" dialog box that appears, select "Place in This Document" from the left-hand side.
- You will see a list of available worksheets in the current workbook. Select the worksheet (Worksheet B) where the date is located.
- Choose the cell with the date you want to link to in Worksheet B.
- Click "OK" to insert the hyperlink.
- The selected cell in Worksheet A will now have a hyperlink to the cell with the date in Worksheet B.
Please note that if the name of the workbook file is causing issues, make sure that both worksheets are in the same workbook. Also, ensure that you have saved the workbook before inserting hyperlinks, as sometimes Excel might not be able to resolve cell references in unsaved workbooks.
Remember that when you click on the link in Worksheet A, it will take you directly to the linked cell in Worksheet B where the date is located. If the cell content changes in Worksheet B, it will reflect in Worksheet A as well. The text and steps were created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
