+ Reply to Thread
Results 1 to 6 of 6

VBA Auto Cut and Past date

  1. #1
    Registered User
    Join Date
    09-15-2015
    Location
    england
    MS-Off Ver
    2013
    Posts
    19

    VBA Auto Cut and Past date

    https://www.dropbox.com/s/c98wh0q52t...2222.xlsx?dl=0

    hi i had a spread sheet for my accounts for car trade and some one gave me this code:

    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Dim dt As String
    If Target.Cells.Count > 1 Then Exit Sub
    If Len(Sh.Name) <> 3 Then Exit Sub
    Application.EnableEvents = False
    If Not Intersect(Target, Range("C3", Cells(Rows.Count, 3).End(xlUp))) Is Nothing Then
    dt = Format(Range("C" & Target.Row).Value, "mmm")
    Sh.Range("A" & Target.Row).Resize(1, 9).Copy
    Sheets(dt).Cells(Rows.Count, 1).End(xlUp)(2).PasteSpecial xlPasteValues
    Sh.Range("A" & Target.Row).Resize(1, 9).ClearContents
    End If
    Application.EnableEvents = True
    End Sub

    but now i am making a new one so if any one could help me please
    the new range is from Column A to X Row 1260 to 2000
    Column of Sold Date start from B 1260 to B 2000
    got 14 Worksheet 12 months of the year from Apr to Mar one Total and the last one Make And Models
    got a formula in Column K,P and V i dont know if u need to know that

    all what i want is when i put the sold date the row of the information of the car move to the right month Exemple
    i have bought a car in April witch is all the information will be in worksheet Apr and sold it in May so when i put the sold date i want the row from A to X of the right car move to worksheet May
    the old code was working perfect apart from when i put the sold date in the same month used to go to the bottom of the list and leave empty row at the top if there is any way to repair that

  2. #2
    Registered User
    Join Date
    09-15-2015
    Location
    england
    MS-Off Ver
    2013
    Posts
    19

    Re: VBA Auto Cut and Past date

    if any one can tell me please if its possible or not

  3. #3
    Registered User
    Join Date
    09-15-2015
    Location
    england
    MS-Off Ver
    2013
    Posts
    19

    Re: VBA Auto Cut and Past date

    if any thing not clear let me know please
    any one can tell me way no one could resolve my problem?
    not clear ?
    to hard ?
    take to much time?
    not possible?

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA Auto Cut and Past date

    Hello New Friend,

    Try this and let me know:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  5. #5
    Registered User
    Join Date
    09-15-2015
    Location
    england
    MS-Off Ver
    2013
    Posts
    19

    Re: VBA Auto Cut and Past date

    xladept i dont no how to thank you my new Friend

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA Auto Cut and Past date

    You're welcome and thanks for the rep!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Rolling Tracker - Auto delete cells as a date is past
    By cab1979 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2015, 06:43 AM
  2. [SOLVED] Auto fill a column based on date and color a column if past that date
    By thegunder in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2013, 03:06 PM
  3. [SOLVED] Calculate total dollar amount the is past the past due date
    By Barb1980 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-12-2012, 05:34 PM
  4. Replies: 1
    Last Post: 09-30-2012, 03:01 PM
  5. Replies: 5
    Last Post: 08-22-2012, 05:06 PM
  6. excel 2002 help to auto-delete past dates
    By chetman in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-23-2009, 05:21 PM
  7. auto copy and past
    By cdixon in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-23-2006, 11:55 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