variable sheet name

  1. N

    Sheet Name from cell value in formula - Not Volatile (INDIRECT)

    I could not find this in another thread so please point me there if it exist. I've been using INDIRECT when I need to use a refer to tab name based on a value in a cell, but it uses the volatile INDIRECT formula. Is there a better way to do this using INDEX or something that isn't volatile...
  2. K

    Hyperlink with variable workbook and sheet name

    Hello there! How can I use "HYPERLINK(link_location, [friendly_name])" with variable workbook and sheet name and spece between their names. I linked the "[friendly_name]" to sheet name.The argument "[friendly_name]" doesn't allow the hyperlink to work if there's a space between either...
  3. S

    Variable Sheet Names

    I am working on a macro that enables automation of data collection from different sheets into one sheet in the same workbook. I think I have the code as it should be in logic, but there are inconsistenicies in the syntax. I have highlighted these two lines in red below. I tried to help...
  4. D

    INDIRECT with Variable Sheet Name

    Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> <o:p></o:p> In Sheet 01, cell C58 holds the month (as text), D58 holds the day number (as extracted from sheet name), and E58 holds the year (as number). I have other cells on this sheet that...
  5. E

    Help with Indirect Reference

    I'm trying to do a vlookup (in a cell, not VBA) where the range is determined by a variable stored in another cell. =VLOOKUP(TRIM(A3)&"*",'\\030-DC1\Company$\ADOE 30\re-entry calc\[ReEntry Calculations.xlsx]August 13'!$A$2:$N$150,6,0)That is the lookup without the variable. It works great. I...

Some videos you may like

This Week's Hot Topics