Results 1 to 8 of 8

Copy,Cut, Paste Row to different sheet when date entered becomes todays date - Please Help

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2016
    Location
    Raleigh, NC
    MS-Off Ver
    2010
    Posts
    9

    Copy,Cut, Paste Row to different sheet when date entered becomes todays date - Please Help

    I have three identical worksheets named Sold, Delivered, and Closed
    I want rows to automatically copy, cut, and paste from Delivered to Closed – WHEN…
    The date that is previously entered in column H becomes “Todays Date”.

    This is code I have set on the Sold sheet that works very well for moving rows from Sold to Delivered when the trigger word “Delivered” is selected from a dropdown in column F. I’ve tried altering this code with words like CurrentD, TODAY(), to work to move rows from Delivered to Closed when the date entered in column H becomes today's date with no success.

    Private Sub Worksheet_Change(ByVal Target As Range)
     If Target.Column = 6 Then
      If Target = "Delivered" Then
        Application.EnableEvents = False
          nxtRow = Sheets("Delivered").Range("B" & Rows.Count).End(xlUp).Row + 1
           Target.EntireRow.Copy _
            Destination:=Sheets("Delivered").Range("A" & nxtRow)
           Target.EntireRow.Delete
      End If
     End If
     Application.EnableEvents = True
    End Sub
    I need a separate code to put on the delivered sheet that will automatically copy, cut, and paste rows from Delivered to Closed sheets – WHEN…
    The date that is previously entered in column H becomes “Todays Date”. It should be similar to the above code but with a different trigger = when date interred in column H becomes today's date.
    Last edited by Mykull; 03-11-2016 at 10:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autohide Columns that are < todays date and > todays date by 2 & 7 days
    By Dropfiddy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2015, 03:51 AM
  2. Cells copy and paste after date entered
    By keez1993 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-24-2015, 10:51 AM
  3. Use VBA to Search for Todays Date from an array of Date and Paste Value
    By davis6774 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2013, 07:11 PM
  4. Copy/paste row with todays date in Sheet2 to sheet 3....but from Sheet 1
    By cammyjane10 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-25-2013, 01:07 PM
  5. Cut and paste a row to another sheet after a date is entered into a cell
    By findleydd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2011, 09:49 PM
  6. 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
  7. Replies: 3
    Last Post: 05-28-2008, 01:32 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