+ Reply to Thread
Results 1 to 6 of 6

Copy rows from worksheet to another worksheet that date is not current year

  1. 02-01-2016, 02:53 PM #1
    Lottoman is offline
    Registered User
    Join Date
    02-01-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    2

    Copy rows from worksheet to another worksheet that date is not current year

    Hi I am trying to find a way to move all rows (can be deleted from original worksheet) to a separate worksheet in the same workbook where the date field year does not match current year.

    So something like:

    Task1 Description 01/01/2014
    Task2 Description 01/03/2015
    Task3 Description 01/01/2016

    So the first two records would be moved to another worksheet leaving just Task3 in the current worksheet, based on the year portion of the date. I would like to add the code to a macro to run whenever and move tasks from previous years to the historic task sheet.

    Appreciate any help

    Running Office 2010

    Thanks
    Reply With QuoteRegister To Reply
  2. 02-01-2016, 02:57 PM #2
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Copy rows from worksheet to another worksheet that date is not current year

    Hi,

    And welcome to the forum

    I'd use a helper column D with with a formula like

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Then get a macro to use a Data Filter Advanced to filter the data for FALSE and copy the filtered data to your archive sheet before deleting the filtered rows.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 02-01-2016, 03:03 PM #3
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Copy rows from worksheet to another worksheet that date is not current year

    macro-
    Please Login or Register  to view this content.
    Check attached.
    Press button for results.
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh
    Reply With QuoteRegister To Reply
  4. 02-01-2016, 03:11 PM #4
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,026

    Re: Copy rows from worksheet to another worksheet that date is not current year

    Maybe: 
    Please Login or Register  to view this content.
    This assumes the dates are in column C starting in row 2. The copying is done to Sheet2. It will also work regardless of what the current year is.
    Last edited by Mumps1; 02-01-2016 at 03:13 PM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  5. 02-01-2016, 03:37 PM #5
    Lottoman is offline
    Registered User
    Join Date
    02-01-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    2

    Re: Copy rows from worksheet to another worksheet that date is not current year

    Thanks everyone for your prompt replies. This has helped me a great deal.
    Reply With QuoteRegister To Reply
  6. 02-01-2016, 03:38 PM #6
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,026

    Re: Copy rows from worksheet to another worksheet that date is not current year

    Glad it worked out. :
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy current month named worksheet and paste into a static worksheet
    By Jissenka in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2015, 11:28 PM
  2. [SOLVED] Count current year in worksheet
    By Alfexcel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-26-2014, 08:58 PM
  3. [SOLVED] Using a start and end date to copy paste rows to another worksheet
    By Anada in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-31-2014, 08:46 AM
  4. [SOLVED] Select, Copy and Paste a range within in Worksheet based on current date
    By reynoldslarry in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-02-2014, 06:23 PM
  5. Keep month and date but change year to current year and reoccur when new year rolls over.
    By cdixon01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  6. IF end of report in other worksheet, do not copy cell above in current worksheet
    By ciayers in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2013, 12:58 PM
  7. Copy Row from Previous Worksheet to Current Worksheet
    By Petrolcb41 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2010, 01:39 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1