•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Hyperlink formula ‘drag fill’ pulls Friendly Name of the sequential cells I want correctly, but hyperlinks me to the same cell in the sheet.
Our take
Are you frustrated by hyperlinks in your spreadsheet not pointing to the correct cells? Many users face this challenge when setting up an Index sheet that pulls data from multiple tabs. Instead of simply displaying the ‘Friendly Name,’ you want each link to direct to the corresponding sequential cell. By utilizing the right formula, you can transform your Index into a dynamic tool that enhances navigation and data accessibility. Read on to discover how to adjust your hyperlink formula for seamless referencing across your workbook.
In the first tab/sheet of my workbook I have created an Index of data from multiple sheets in the same workbook. I initially used the =SHEETNAME!CELL formula to just pull the data (last names).
What I would prefer is that the cells in my Index include both the data from the cell I’m pulling from (aka the ‘Friendly Name’) AND a hyperlink directly to that cell in that sheet.
The data I’m pulling from the multiple other sheets in the workbook, is sequential. I tried to use the =HYPERLINK(“#’SheetName’!A2”,SheetName!A2) formula —where A2 is the first cell in a sheet with information ai want to pull up to my ‘Index sheet’.
When I drag the formula on my Index sheet, the formula correctly pulls the Friendly Name from A3, A4, A5, etc but the hyperlink continues to bring me to the A2 cell on the sheet. I have googled, used chatGPT, copilot, Microsoft Support but I can’t seem to articulate my inquiry as I keep receiving the instructions for the basic Hyperlink formula or unhelpful how-to videos.
How do I get the formula to hyperlink to sequential cells from other sheets when I drag the formula on my Index sheet?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Links to a cell within current worksheet keep changing the location, or doesn't work at all.I have a series of titles at the top of my worksheet with links to the most popular categories, hopefully to get to those categories quickly for data entry. I right click on the cell where I want the link, select Link, the enter the cell reference I want to jump to, with the text to display. This works. It presents a link, and if i click on the link, it jumps to exactly where I want it to go. However, over time, the cell reference isn't correct, and jumps to something else. I assume this is happening due to modifications of the worksheet or what it's from. I do not use "$" in the cell reference, assuming that if I enter A720 as the cell reference, the reference will automatically be modified to A730 if 10 rows are added. I have enough of these links that I shouldn't have to modify all of them each time there is an insertion or deletion. I tried using the formula =HYPERLINK(A730, "Category1") or =HYPERLINK('Shawna Smith'!A730, "Category1"), and neither of these work at all. It does not jump to A730 when I click on it. What am I doing wrong, or should I be using another feature or formula? Thank you for your help. https://preview.redd.it/nb4q3dm883tg1.png?width=649&format=png&auto=webp&s=cfc0c9e7f2d7e9d620075eebf6def8e7500f09fa submitted by /u/KatMagic1977 [link] [comments]
- Click and drag to link file to cell?I need to link to pdf-files from specific cells in a table. Hence, I right click the cell, select ‘Link’ and browse for the file within the file tree and select it. But having to do this individually for every single table row is time-consuming. Is there any way I could just click and drag the file into the table? Alternatively, it would be much easier if the files in the ‘Insert Hyperlink’ dialog box were sorted with the most recent file on top, but they’re always sorted alphabetically, it sems. Is there any way to change this? Down the road I’ll have several hundred pdf files to link to in the same folder and often with relatively similar names, so making sure I link to the correct file becomes even more of an issue. submitted by /u/Serious-Assistance12 [link] [comments]
- Hyperlink does not update when manually changing the date within the URLI have a hyperlink to a web site that is 425-450 characters depending on the account. I have issues. The dates inside the URL change based on month so I cannot hard code the URL in the cell, even though this gets around the function's 255 character limitation when I click on the link. I hard coded the date to April in the URL and it worked, giving me the April data webpage. However, I then did a find/replace to change the date parameters to March dates then clicked on the link, I still got the April data webpage, even though the URL in the Excel cell had March dates. If I choose to hard coded URL and find/replace the dates, how can I make the URL in the Excel cell update to the new date parameters? The webpage did update to March when I clicked on the cell then pressed F2 then click on the link, but I don't want to have to do that for 300 lines. Or, can I use Power Query to help me still use the Hyperlink function, so that the cell only displays the Account number and still work on the ridiculously long URLs? submitted by /u/magickrhythm [link] [comments]
- Hyperlink on Excel MobileI am building a complex spreadsheet for an operational task at work. Without going into detail essentially employees that are out on the road will use cell phones or tablets to enter data for employees that are at the home office to print. The current set up is chaos. In my workbook, there are many hyper links that on desktop are one touch however, in mobile, you have to click, two sometimes three drop downs to open the link. I have a mixture of formula hyperlinks that are title words, button style, hyperlinks attached to a text box or picture that are above the cell and within the cell. They all do the same thing. In Excel online some perform as one touch and some you have to open the link then click the link. It would be fine if the clicking wouldn’t result in hyperlinks getting deleted or messed up and I have too many tasks to micromanage the corrections. Does anyone have any suggestions on how to make these perform as one touch on mobile? submitted by /u/Present_Brush7357 [link] [comments]