+ Reply to Thread
Results 1 to 10 of 10

Moving items between sheet based on a selection

  1. #1
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Moving items between sheet based on a selection

    I have two pages one is called Due and one is called Completed. If one of the tasks in the Due sheet is marked completed it should move only the values from that line and exclude columns C, D, F to the Completed sheet. It should also work in reverse so if on the Completed page I select reschedule it will move the values back to the Due sheet. I have this a good portion completed however I cant figure out how to exclude the columns, copy & paste only the values, remove data from page after it is moved, and get it to insert into the table it is inserting data after the table. Would also to be nice if when it was moved from Due to Completed it put the date it was moved as an archived date.

    Here is a copy of the workbook

    Thank you for looking and hopefully someone can assist with this providing it isnt too much work.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Moving items between sheet based on a selection

    Problem lies in the order of the columns on sheet Due. If the order would be Class (A), Task (B), Due Date (C), Priority (D), Status (E), Days Left (F) then you would only have to move columns A-C which are consecutive cells and thus can be handled as a range.
    BTW, where would Due Date go in the sheet Completed?
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Moving items between sheet based on a selection

    No due date on the completed page as it is being archived so a due date wouldn't apply any longer. was thinking of changing that to a Archived date after it was moved. So actually A B C are the only ones that would be moved since D and E are slightly different on the other page. D would be to either archive or reschedule and E would be the date it was moved there and if it was rescheduled it move only A B C from the completed to the due
    Last edited by Mr_Bill; 09-25-2014 at 03:39 PM.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Moving items between sheet based on a selection

    Please find the attached sheet to see if this works as per your requirement.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  5. #5
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Moving items between sheet based on a selection

    That works beautifully Thank you..

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Moving items between sheet based on a selection

    You're welcome and thanks for the feedback.

  7. #7
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Moving items between sheet based on a selection

    Not a big deal but was curious when it moves the data is it possible to set the status? So for example if its moved from the completed to the Due it would have a not started status. Going from due to completed the default would be archived. Not a big deal to do it by hand if its a large undertaking.

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Moving items between sheet based on a selection

    See the attached sheet.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Moving items between sheet based on a selection

    That is outstanding thank you so much. I wish I could do these things on my own one day I will.

  10. #10
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Moving items between sheet based on a selection

    You're welcome.
    Sure, you will. In fact this is very simple and basic code and if you observe it carefully, you will be able to write it yourself.

+ 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. moving selection from one sheet to another
    By Josh Conley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2014, 01:48 PM
  2. Moving select items based on criteria from one worksheet to another
    By alihamdan0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2014, 05:56 PM
  3. [SOLVED] Particular items are shown based on a dropdown selection
    By mathieuv in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2013, 11:47 AM
  4. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM
  5. Moving Items to bottom of spreadsheet based on criteria
    By Noel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-13-2005, 02:06 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