+ Reply to Thread
Results 1 to 9 of 9

move entire row to differnt worksheet when date has passed

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    Norfolk, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    5

    move entire row to differnt worksheet when date has passed

    I have a spreadsheet that i need to track all past and future schools for the next year. From J7 down i have the date that the school starts. i was wondering if there is anyway to make the entire row move over to another spreadsheet once the date has passed. So i can have two differnent tabs with future schools and past schools. Any help would be greatly appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: move entire row to differnt worksheet when date has passed

    Hello there,

    Would you to copy the new information to another worksheet and delete the information from the first worksheet? Also, everytime you perform this action are you adding the copied data from the first worksheet to a new worksheet or adding it to the bottom of the previously created new worksheet?

    Thanks!

  3. #3
    Registered User
    Join Date
    08-08-2012
    Location
    Norfolk, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: move entire row to differnt worksheet when date has passed

    Yes once the information is coppied to the new worksheet i would delete it from the first worksheet and i would keep adding it to the bottom of the previously created worksheet. So i would only have two worksheets one with future dates and one with past dates. Thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: move entire row to differnt worksheet when date has passed

    Could you please provided a sample of you workbook mimicing what you would like your results to be?

    Thanks!

  5. #5
    Registered User
    Join Date
    08-08-2012
    Location
    Norfolk, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: move entire row to differnt worksheet when date has passed

    Attached is an example of my workbook of what i want to automattically happen once the date has passed. Thank you.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: move entire row to differnt worksheet when date has passed

    Hello there,

    Attached is your sample worksheet update to include a code that runs when the workbook is open.

    Be sure to enable macros when opening the workbook for it to work properly.

    To incorporate this code into your workbook:

    1. Press Alt+F11 on your keyboard.
    2. This will bring up the visual basic window
    3. On the left hand side you should see a ThisWorkbook option.
    4. If you don't pres Ctrl+R to bring up the Project Explorer
    5. Right click on ThisWorkbook and then select view code
    6. Copy and paste the below code in the blank space provided.

    Please Login or Register  to view this content.
    7. Close out of Visual Basic and then you should be good to go.

    Let me know if this works for you.

    Thanks!
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-08-2012
    Location
    Norfolk, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: move entire row to differnt worksheet when date has passed

    Thank you!

  8. #8
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: move entire row to differnt worksheet when date has passed

    Glad to help! Thanks for the star tap!

  9. #9
    Registered User
    Join Date
    08-13-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: move entire row to differnt worksheet when date has passed

    Quote Originally Posted by rvasquez View Post
    Hello there,

    Attached is your sample worksheet update to include a code that runs when the workbook is open.

    Be sure to enable macros when opening the workbook for it to work properly.

    To incorporate this code into your workbook:

    1. Press Alt+F11 on your keyboard.
    2. This will bring up the visual basic window
    3. On the left hand side you should see a ThisWorkbook option.
    4. If you don't pres Ctrl+R to bring up the Project Explorer
    5. Right click on ThisWorkbook and then select view code
    6. Copy and paste the below code in the blank space provided.

    Please Login or Register  to view this content.
    7. Close out of Visual Basic and then you should be good to go.

    Let me know if this works for you.

    Thanks!
    Hello

    I'll be using your work as a reference will that be ok??? This is related to what I want to do, thanks for your work sir.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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