Results 1 to 17 of 17

Moving rows to another sheet based on a certain field's value

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2011
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2003
    Posts
    4

    Moving rows to another sheet based on a certain field's value

    Hi Excel experts,
    I am working on a worksheet, and would like to have an entire row transferred to another worksheet based upon a certain cell's value.

    Having searched through the many solved threads on this site, I attempted to customize some of the code to my worksheet. Not being proficient in Macro/VBA, I failed. I figured I would ask for help, and see if anyone can provide what I am looking for.

    Basically, I am attempting to construct a "work in process" file, and would like all completed work to be deleted from the work in process sheet, and transferred to a sheet that contains a running list of all work completed.

    Attached is an example of what I am working on. I would like Column Q (Status) to determine if a row can be moved to a sheet that contains the list of all work completed, and eliminated from the original sheet. Once Status is updated to "Complete", it would be helpful to be able to run a macro/click a button that would perform the transfer.

    Can anyone assist?

    Thanks!
    Attached Files Attached Files
    Last edited by anthonymariani1982; 03-03-2011 at 01:05 PM.

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