| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic hyperlink
Hello excel experts,
I have a sheet with dates from Jan 1 to Dec 31 in one column. My requirement is have a cell "Today" which will automatically link to the correct date. i.e. when I press this link, it should take me to the cell with today's date. Could someone pelase help ? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamic hyperlink
Assuming dates are in Column A, in Sheet1 and in file called Book1
=HYPERLINK("[Book1]Sheet1!A"&MATCH(TODAY(),A:A,0)) " wrote: Hello excel experts, I have a sheet with dates from Jan 1 to Dec 31 in one column. My requirement is have a cell "Today" which will automatically link to the correct date. i.e. when I press this link, it should take me to the cell with today's date. Could someone pelase help ? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamic hyperlink
If I am correct, please rate my answer.
" wrote: Hello excel experts, I have a sheet with dates from Jan 1 to Dec 31 in one column. My requirement is have a cell "Today" which will automatically link to the correct date. i.e. when I press this link, it should take me to the cell with today's date. Could someone pelase help ? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
| Dynamic Hyperlink | Excel Worksheet Functions | |||
| answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Can I create a dynamic email address in Excels hyperlink? | Excel Worksheet Functions | |||
Linear Mode
