+ Reply to Thread
Results 1 to 5 of 5

Changes to lookup data to only affect ROWs with todays date or greater instead of all data

  1. #1
    Registered User
    Join Date
    04-06-2020
    Location
    London
    MS-Off Ver
    Office for MAC v16.35
    Posts
    6

    Changes to lookup data to only affect ROWs with todays date or greater instead of all data

    Hi all,

    I have a previous post that is now solved thanks to Kaper - Many thanks.

    But I have run into a new problem with the same spreadsheet:

    where any changes I make to the lookup data affects all data when I would like it to only affect ROWS with today's date or greater (future).

    This is a problem as I need to refer to dates in the past and be confident in who was working.


    Thanks in advance and interested to hear how you would solve this.




    Link to related thread: (can't post links, sorry)
    Title of related thread: Populate column with names from 2 lists of people with criteria

    I will also post the same dummy spreadsheet.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Changes to lookup data to only affect ROWs with todays date or greater instead of all

    Can't think of any way of doing this that doesn't involve replacing the formulae for days past with a static value.

    You could do this using the Workbook_Open() event, Worksheet_Change() event and others, but the workbook would then have to be a macro-enabled one. For example:
    Please Login or Register  to view this content.
    Would that do the trick?

    Tim
    Never stop learning!
    <--- please consider *-ing !

  3. #3
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Changes to lookup data to only affect ROWs with todays date or greater instead of all

    NB You could put your "Rota" in a table and use qualified table references instead of hard-coding the ranges. Then the data could change without messing up the VBA.

  4. #4
    Registered User
    Join Date
    04-06-2020
    Location
    London
    MS-Off Ver
    Office for MAC v16.35
    Posts
    6

    Re: Changes to lookup data to only affect ROWs with todays date or greater instead of all

    Thank you and sorry for the late reply.

    This did do the trick and I took your advice on table references and got that working.

    will mark as SOLVED and send some *

  5. #5
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Changes to lookup data to only affect ROWs with todays date or greater instead of all

    Glad it's sorted, and thanks for the rep.

    Tim

+ 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. date column to look up todays date and copy/paste in same row as date lookup
    By fst100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2019, 07:48 AM
  2. Average if data is before todays date
    By tompee29 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2014, 09:19 AM
  3. Filter data by date (within 3 months of todays date)
    By Gti182 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2014, 01:42 PM
  4. Replies: 3
    Last Post: 12-10-2012, 06:57 AM
  5. Replies: 3
    Last Post: 05-28-2008, 01:32 PM
  6. Data for todays date and before
    By djfatboyfats in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2008, 11:09 AM
  7. How do I filter a list using a greater than todays date function?
    By LV in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2005, 02:06 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