+ Reply to Thread
Results 1 to 5 of 5

Automatically Move Rows When one Column meets a Criteria

  1. #1
    Registered User
    Join Date
    01-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Automatically Move Rows When one Column meets a Criteria

    My Lords, and Ladies,

    I have in my company a workbook of many sheets and many columns. There is a sheet liqrSCH which contains a list of all the sites we have scheduled for the year. In Column K [Implementation Status] we track the status of the visit (e.g. scheduled, postponed, removed). Whenever a user changes the implementation status to either of Completed, Postponed, or Removed I would like the whole row (columns A:AM) to be transferred to the respective spreadsheet. To give you some examples below...

    Site ID 0001 implementation status changed to = "Removed" -> transfer to liqrRMVD worksheet
    Site ID 0002 implementationstatus changed to = "Postponed" -> transfer to liqrPPND worksheet
    Site ID 0003 implementation status changed to = "Completed" -> transfer to liqrCPTD worksheet

    Any help would be sincerely appreciated by the people of my kingdom.

    With Thanks,
    Mr. B

  2. #2
    Registered User
    Join Date
    01-21-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Automatically Move Rows When one Column meets a Criteria

    Please Login or Register  to view this content.
    Last edited by sky1in5; 01-23-2013 at 11:44 PM.

  3. #3
    Registered User
    Join Date
    01-21-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Automatically Move Rows When one Column meets a Criteria

    change sheet1 to your master list..

  4. #4
    Registered User
    Join Date
    01-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Automatically Move Rows When one Column meets a Criteria

    Unfortunately it is not working for me -- would you please confirm I need to paste the code provided in the code for that worksheet rather than a module or the workbook code?

  5. #5
    Registered User
    Join Date
    01-21-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Automatically Move Rows When one Column meets a Criteria

    what is your data base worksheet name? press alt + f11 and right click insert a module on the left side of screen and paste it in the module and run.

+ 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