+ Reply to Thread
Results 1 to 4 of 4

Matching Based on Today being Between Two Dates (Macro)

  1. #1
    Registered User
    Join Date
    06-20-2023
    Location
    Usa
    MS-Off Ver
    2013
    Posts
    2

    Matching Based on Today being Between Two Dates (Macro)

    Hi every one

    I need a macro to verify if TODAY is between two different Date and if match then copy a Cell from another worksheet and paste in active worksheet and Loop it from I=1 to 100 e.g.

    thanks
    Last edited by AliGW; 06-20-2023 at 11:15 AM. Reason: Thread title improved - generic thread titles are NOT permitted.

  2. #2
    Valued Forum Contributor
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    2021
    Posts
    324

    Re: Macro required

    Hello @s.hme, Like example.
    Please Login or Register  to view this content.
    Think further what you need.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,796

    Re: Matching Based on Today being Between Two Dates (Macro)

    @s.hme

    Please review our rules on thread titles - yours was generic, so I have changed it. Make sure you meet our requirements in future, please.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    06-20-2023
    Location
    Usa
    MS-Off Ver
    2013
    Posts
    2

    Re: Matching Based on Today being Between Two Dates (Macro)

    Thank you for your kind reply

    The DATE required to be inside the loop meaning that the macro required to find that Today is matching with which bi-weekly report.

    every two weeks there are new data and the data goes from column n to z e.g. the macro required to bring the date which the DATE is matching with the bi-Weekly report date and bring the data to other sheet.

    If I can attach example excel sheet, I will explain more properly.

    Thank you and best regards

+ 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. Simple changes in macros required
    By Sekars in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2022, 10:31 AM
  2. Simple changes in macros required
    By Sekars in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2022, 04:22 AM
  3. Help Required in Macro. When assigning macro to button its not working
    By A9kurs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2020, 04:31 PM
  4. Replies: 3
    Last Post: 07-15-2016, 12:39 PM
  5. Macro Help required
    By kamalthakur in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2008, 09:52 AM
  6. Replies: 1
    Last Post: 05-13-2005, 11: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