+ Reply to Thread
Results 1 to 1 of 1

Auto move a row to a second sheet when all fields are entered and a field says complete

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Office 2010 (Excel)
    Posts
    50

    Auto move a row to a second sheet when all fields are entered and a field says complete

    I have absolutely NO clue about excel. I am self taught in the limited knowledge i do have.
    Can someone please, blow by blow, explain how to do something...

    I have several fields on the 'OPEN' tab. Each MUST be populated, and the S column has a dropdown box saying Complete, which must say this before moving the whole row to the 'CLOSED' tab.

    Similiarly, if someone wants to reopen the case, there are several other options apart from Closed, ie open, quarantine etc, and if the status is reopened in any way and it doesnt say the word closed, i want it to move back to the top row of the 'OPEN' tab sheet...

    Can someone please tell me what to do, bit by bit...

    Thank you!

    Sheet attached
    Attached Files Attached Files
    Last edited by teenyjem; 08-08-2012 at 09:50 AM.

+ 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