Results 1 to 11 of 11

Moving rows from one sheet to another according to Status

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    17

    Post Moving rows from one sheet to another according to Status

    I have 7 columns (Company, Service Order, Type, Model, Date, Warranty, and Status). Each column has a drop down list (except the Service Order and Date).

    Under Status I have a drop down list with a few options.
    Inbound, Checked In, Evaluated, and etc...

    I have 4 sheets (Inbound, In_House, In_House2, and Past record), each with it's own table (some with 2 tables). This is how far I have been able to get:
    I manage to set a code to add 'New Entries' on the Inbound sheet for incoming repairs with it's corresponding drop down list.

    I tried a few codes to move the rows corresponding with the Status column (Inbound, Checked In, Evaluated, Approved, etc...). However, I had no luck and kept getting errors or it would remove all the rows and replace the table on the other sheet with the rows (close but no cigar).

    So....a little help on cutting a Row from one table and moving it to another table in another sheet, corresponding to the Status Column. If I can get the first sheet working, I should be able to do the rest.

    test1.xlsm

    Thank you everyone for looking over my worksheet
    Last edited by warri0r; 01-23-2013 at 10:04 AM.

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