Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
excel [2020/02/03 09:53] – [Macro to create link for each worksheet] gerardorourkeexcel [2020/02/07 14:09] (current) – gerardorourke
Line 126: Line 126:
   * <code>=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")</code>   * <code>=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")</code>
   * Have a worksheet with A column with number of sheets on each row. and Use a formula to create hyperlink to all worksheets    * Have a worksheet with A column with number of sheets on each row. and Use a formula to create hyperlink to all worksheets 
 +  * <code>=INDEX(ListSheets,A1)</code>
 +  * then use the below to get the URL link for the worksheet
   * <code>=HYPERLINK("#'"&B1&"'!A1",B1)</code>   * <code>=HYPERLINK("#'"&B1&"'!A1",B1)</code>
  
 Reference: https://www.datanumen.com/blogs/3-methods-to-create-a-list-of-hyperlinks-to-all-worksheets-in-an-excel-workbook/ Reference: https://www.datanumen.com/blogs/3-methods-to-create-a-list-of-hyperlinks-to-all-worksheets-in-an-excel-workbook/
  
- +Dependant Dropdowns 
 +  *https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/
  • excel.1580723585.txt.gz
  • Last modified: 2020/02/03 09:53
  • by gerardorourke