hyperlinks

I am just a common user of Excel trying to do uncommon things and wishing I could do more. Would appreciate answers written in "layman's" terms as I certainly don't understand anything related to coding such as VBA. :confused: Working on a project that is intended to be used by people who know...

Hi, I am using Excel 2013 and I am experiencing a problem trying to create a number of Hyperlinks from two Worksheets to a third within the same Workbook. In the Workbook there are three sheets. The first Worksheet is pretty constant whilst the other two change on a weekly basis. Worksheet 2...

Hi there, I have a series of hyperlinks on a tab that when clicked i want to hide/unhide specific rows. I have looked around online and realize i cannot have more than one Worksheet_FollowHyperlink but that i can build a macro that calls on other macros to work around this. i have built...

Hi, I need my Master Data Table to transfer Hyperlinks to Pivot table. I have seen lots of VBA coding, however not much for hyperlinking to computer files and not web links. Can anyone help me?

Hello all, I have a list of website bookmarks, not hyperlinked, just text. They are all listed in column A. I know i can select each one and choose "hyperlink" and copy the link and paste it to manually create a hyperlink but is there a formula to automatically create the hyperlink? I have a...

I would like to use a Excel sheet to manage the links on several google sites, such that I create links on my sites to the contents of a cell in an Excel spreadsheet, which contains a link to another document. This would enable editors of the spreadsheet to change the results of the links in the...

Hello, I have a workbook with hyperlinks to files on my PC. How can I highlight a range of these hyperlinks and have them all open please? They are all pdf files if that makes a difference.

Hi everyone i have two questions i need help with. 1st. Is when i am using external data that is imported into excel from the web, Hyperlinks on the websites table does not get transferred into excel but instead just text. Is it possible to change this so it imports working hyperlinks. (Using a...

Hi, I have outlook email which is in table format and the content in the table has data with Embed Hyperlinks. I tried the below code. I am getting all the data from the table to excel but i am not getting the Embed Hyperlinks. Can you please help in getting the Hyperlinks which are Embed to...

I have a spreadsheet where the basic function is to merge information from two worksheets. One sheet has a column hyperlinks (to external web pages) and a unique date for each row. The other sheet has descriptive information, tags, etc. I now have all the data merged, sorted, and formatted the...

Hello, I have a big Excel file with many worksheets&hyperlinks to other documents all over my PC. After I update to Win10 the path for documents (and hyperlinks) is changed: Old = C:\Users\nzw\AppData\Roaming\Microsoft\Excel\... New = C:\Users\nzw\AAA\... The "..." contains the rest of path...

Hi all, As you know, when an hyperlink is clicked in excel or in other applications, its text color changes visually indicating that the link has already been followed. The color is reset to its default when re-opening excel. (Depending on the update automatic links at open setting) I am...

I have an excel workbook with a bunch of hyperlinks built into the worksheet cells. These hyperlinks all point to other cells/sheets within the same workbook. The problem is that people keep accidentally clicking the hyperlinks, and getting involuntarily bounced around the workbook. I'm...

I have the following problem. Sheet 2 has a list of names and hyperlinks to other sheets (hyperlinks work) On sheet one I have created an” Index - Small” formula that searches sheet2 and brings back the results on sheet1...

I have a spreadsheet that is used to maintain stock in a warehouse. As below: Column A had hyperlinks in it that linked to folders and excel spreedsheets on a NAS storage drive. However since a computer update the links have changed. As you can see in the image below I have highlighted one...

Hello - I have a list of hyperlinks that open a userform. Each hyperlink is tied to a unique row of data in the range. The hyperlinks each refer to a unique named range based on the data in that row. I need users to be able to filter this list in order to organize the rows in various ways. My...

Hello, I need to find a way to make the subaddress of my hyperlinks change as rows in my sheet are deleted. Essentially, the code I have below creates a hyperlink on the same line that input from a userform is transferred to. When the user clicks the newly created hyperlink, they move the...

I want to put multiple hyperlinks in one cell. I have a cell that has a list of problems and I want each one hyperlinked to a picture. I have the following hyperlink I am using =HYPERLINK($B$1&""&"pic1.jpg","jpg1.pic") and it works fine when it is in a cell by itself. But to put multiple...

I am creating an excel sheet for a client and it has many picture names hyperlinked to actual pictures. The problem I have is the I don't know where the client is storing the pictures. So Joe could store them on a network drive and Bill could have them on an external drive and Carol could...

Hi Need help with auto incrementing a network path in excel 2010... for example: column B contains a random list of numbers starting at cell B2 and going upto B101: A B C D E 1 2 234 3 239 4 111 5 553 6 312 7 876 8...