directory hyperlink

  1. S

    Referencing via Hyperlink

    Hi All, I have an unusual question I am really hoping you can all help me out. I have a "Master Spreadsheet" that references to multiple other spreadsheets and their specific cells. This is done by inputing the directory and the referencing cell (e.g A1) into the master spreadsheets cell. e.g...
  2. G

    Directory lookup with hyperlinks?

    Hi I have the Macro below that will search throught a directory and list the .Xls in it. What I am now trying to do with this is to create a hyperlink from the results that will take me right to the spreadsheet? Is there anything i can easily put in Thanks to anyone that can help :) Sub...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top