+ Reply to Thread
Results 1 to 3 of 3

Find the row where today's date is using macro or VBA

Hybrid View

Chypp Find the row where today's... 10-01-2015, 01:41 PM
TMS Re: Find the row where... 10-01-2015, 01:45 PM
Chypp Re: Find the row where... 10-01-2015, 02:03 PM
  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Romania
    MS-Off Ver
    Office 2016
    Posts
    28

    Talking Find the row where today's date is using macro or VBA

    Hello,
    I have a document with several columns of consecutive data. I waste a lot of time scrolling up and down the document to identify the date of today so that I can read the rest of the columns for the current date. Is there a was I could add a Macro, VBA, Excell function, anything at the top of the data that could help me get to the row where the current date is? It would help me a lot. Any help is welcome. Thank you!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,506

    Re: Find the row where today's date is using macro or VBA

    Why not just use AutoFilter on the date column?


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-20-2014
    Location
    Romania
    MS-Off Ver
    Office 2016
    Posts
    28

    Re: Find the row where today's date is using macro or VBA

    Unfortunately that doesn't work since I have 24 tables, all paralel in the same sheet, each one having a different start date and thus, the date of Today is on different rows. If I set up Autofilter for each of them and then remove it to be able to autofilter the next table, it takes about the same time as scrolling up and down. I was thinking of a VBA formula that I can macro on the top of each table which would take me to the date of today on each one. Is there such a thing?

+ 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. Find Today's date
    By PLD60 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2015, 11:10 PM
  2. Macro button to find today's date
    By razor_raef in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-08-2013, 11:23 PM
  3. Find today's date and then add 1
    By brown3218 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-17-2013, 01:21 AM
  4. Find Today's Date function
    By qbrg in forum Excel General
    Replies: 3
    Last Post: 06-20-2012, 02:41 PM
  5. Find today's date
    By Lynneth in forum Excel General
    Replies: 1
    Last Post: 01-05-2012, 08:25 AM
  6. [SOLVED] Can't find today's date
    By Otto Moehrbach in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-12-2006, 05:45 PM
  7. [SOLVED] find cell with today's date
    By James D in forum Excel General
    Replies: 2
    Last Post: 01-16-2006, 06:10 PM

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