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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top