Can I create an "intelligent link" that links to my "today" area of my spreadsheet?

**TimTailor11** · 11-20-2018, 08:16 AM

Hello, I am new here

I have a question about what I am calling "intelligent links".

I have a large spreadsheet being used as a timesheet. It is possible to create a clickable link that takes the user to the "today" section of the file. The problem being that with the passing of each day, the section for today moves down about 20 rows!
Many thanks

T

**davesexcel** · 11-20-2018, 08:26 AM

If the dates are in column A then this will hyperlink to todays date.

Formula:

Please Login or Register  to view this content.

Change the column Letters if column D then #D and D:D

Can I create an "intelligent link" that links to my "today" area of my spreadsheet?

LinkBack

Thread Tools

Rate This Thread

Display

Can I create an "intelligent link" that links to my "today" area of my spreadsheet?

Re: Can I create an "intelligent link" that links to my "today" area of my spreadsheet?

Thread Information

Users Browsing this Thread

Similar Threads

Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas

[SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"

create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

[SOLVED] How to USE """"" cells count """"" change font color

insert>object>create from file. ("link to file" and "display as icon" left .

[SOLVED] create links to check boxes marked "good" fair"and "bad"

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions