hyperlink and formulas

I have a recipe book spreadsheet with a navigation bar to different categories (ex. PREP or HOT etc.). When Selecting PREP, a second list appears with all HYPERLINKS to all of the prep items. The user clicks on the PREP item and the recipe appears. I CAN MAKE ALL OF THIS WORK, but it's a little...

Hi All, I have two sheets, Sheet 1( has Id's and email addresses columns, Each Id has many emails, sometimes blanks too,. Each Id is duplicated into multiple rows in Sheet 1. This is from a database into which emails were put in through a manual process, sometimes with errors and sometimes...

I have just tied to use the hyperlink function in an if formula in a cell. Essentially the formula if condition is if there is no value in another cell then hyperlink to that cell (I use the # prefix ) and if there is a value then use that value. In simple terms if is: =If($A$1=“”...

I am having a sheet in which I want to hyperlink a cell such that it finds text mentioned in formula and moves cursor there For this I am using below formula =HYPERLINK("#ToDo!A" & MATCH("promc1",A:A,0), "display text") Above formula is entered in cell A53 Todo is sheet name in the same...

Hello, I created the top half of the coding below to trigger an input box. What I'm trying to do is to use that result in the second half of the coding in the red text below. The box successfully appears and let's me enter the data then disappears. Nothing else happens. I have tried quotations...

I want to use a code or formula that automatically hyperlinks cells based on their value. For example, one file's name may be R-01, and another S-01. When I type R-01, I want it to take me straight to its respective folder on the shared drive by clicking on it, and S-01 to ITS respective folder...

Hello, I am trying to establish a dynamic hyperlink to cell B3 within a named Sheet within a named workbook that is kept in the same folder, but the following doesn't work: =HYPERLINK("["&INFO("directory")&"FileName.xlsx"&"]"&"SheetName!"&"$B$3") Any idea how to get this working? Thanks

Hello, I was wondering if someone could help. I have a macro which I use as a change record as follows: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If ActiveSheet.Name = "ChangeRecord" Then Exit Sub Application.EnableEvents = False...

Hello, I would really appreciate some help with something I am trying to do or even find out if it is possible, and if so how. I have been looking all over the place but cannot seem to figure it out. I am quite a bit new to using formulas / vba so bare with me. So now to the request I have 2...