Closed Thread
Results 1 to 3 of 3

NEED HELP! Code that copies row of data to another sheet based on text "Complete"/"Delete"

  1. #1
    Registered User
    Join Date
    04-20-2014
    Location
    London
    MS-Off Ver
    Windows Excel 2010
    Posts
    79

    NEED HELP! Code that copies row of data to another sheet based on text "Complete"/"Delete"

    Hi guys,

    In desperate need of some help from you kind strangers.

    I need a helping editing my code that MOVES (not copies) a row of data from one work sheet to another depending on what a cell in the STATUS column says.

    E.G: Cell in (Column7"Status") = Remove -> I want the row of data to then move to "Delete" sheet.
    E.G 2: Cell in (Column7"Status") of Improvement WIP sheet says "Complete" = Move to Workstack -> I want the row of data to then move to "Improvement Workstack" sheet.

    I would like to apply this code to each seperate sheet, so then once a job is completed in WIP i can select status as "Complete" and move it to delete, OR if it is to be put on HOLD I can select "Move to Workstack" to move the row to the appropriate sheet.

    My workbook:

    Sheet 1: Improvement WIP
    Sheet 2: Improvement Workstack
    Sheet 3: Inbound WIP
    Sheet 4: Inbound Workstack
    Sheet 5: Delete

    Column Names in every sheet:
    Col1: Work Item
    Col2: Service
    Col3: Related Priority
    Col4: Owner
    Col5: Role
    Col6: Objective
    Col7: Status
    Col8: Target Date

    1) I currently have the following code which allows me to perform the action for COMPLETE, however I want the code to also apply the same rule for a status that says "Delete" (Move any row with the status "Remove" to the "Delete" sheet).

    2) Currently the code only copies the data but instead I would like it to cut the data.
    Current Code:


    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    04-20-2014
    Location
    London
    MS-Off Ver
    Windows Excel 2010
    Posts
    79

    Re: NEED HELP! Code that copies row of data to another sheet based on text "Complete"/"Del

    I would like to also apologise for the poor use of grammar in my post.

    In a rush to get this project done, I have posted the above text with no care!!

  3. #3
    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: NEED HELP! Code that copies row of data to another sheet based on text "Complete"/"Del

    Quote Originally Posted by Dremzy View Post
    I would like to also apologise for the poor use of grammar in my post.

    In a rush to get this project done, I have posted the above text with no care!!
    Hi,


    ....and unfortunately this is a duplicate post and as such does not comply with Rule 5 of our forum rules. I would normally have closed the later thread but since you've received some responses I'll close this instead. You may continue in your other thread but please note for the future.

    Thread Closed.
    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.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  3. [SOLVED] Delete Rows if a cell does not equal "Finished" or "Complete"
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-27-2013, 12:40 PM
  4. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  5. Replies: 0
    Last Post: 07-17-2006, 09:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1