+ Reply to Thread
Results 1 to 5 of 5

Copying the row based on todays date.

  1. #1
    Registered User
    Join Date
    08-03-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copying the row based on todays date.

    Hi,

    I need to copy rows to sheet1 to sheet2 which matches with today's date. The code dosen't work wit date. Sorry could attach the excel file. I have attached ScreenShot of excel file.

    Excel.JPG

    HTML Code: 

  2. #2
    Registered User
    Join Date
    08-03-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Copying the row based on todays date.

    No One to Help

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Copying the row based on todays date.

    see here http://www.mrexcel.com/forum/excel-q...ased-date.html
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  4. #4
    Registered User
    Join Date
    08-03-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Copying the row based on todays date.

    Thank you John . The code works Well. One more update need to clear sheet2 before transferring the data again.

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Copying the row based on todays date.

    try this
    Please Login or Register  to view this content.

+ 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: 6
    Last Post: 02-19-2014, 11:47 AM
  2. sum week to date values based on todays date
    By nicko54 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-19-2013, 07:48 PM
  3. Highlighting a row based on todays date
    By jez1890 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2012, 05:12 AM
  4. Using VB to find a range based on todays date and todays date +30
    By Steve_al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 09:31 AM
  5. Filling cells with 3 different colors based on date in cell and todays date
    By chinookcrew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-23-2009, 07:36 AM

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