+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    11-20-2018
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    1

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

    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

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,241

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

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

    Formula: copy to clipboard
    Please Login or Register  to view this content.


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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  4. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. Replies: 2
    Last Post: 07-26-2010, 06:59 AM
  7. [SOLVED] create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1