+ Reply to Thread
Results 1 to 2 of 2

Google Sheet Rule - Move Record to different Worksheet based on Status Value

  1. #1
    Registered User
    Join Date
    04-23-2007
    Posts
    31

    Google Sheet Rule - Move Record to different Worksheet based on Status Value

    Hi, I am trying to learn how to move records based on their status.

    I have a simple setup with two worksheets - Active Orders and Completed Orders.

    If an active order has the status of 'Active' - it should only display on the Active Orders sheet. If the status is changed to 'Completed', it should only show on the Completed Orders sheet.

    The record should move immediately as soon as the value is changed.

    Also - on my Completed Orders sheet - the existing records are sorted by Date. The incoming active order should position itself correctly based on the date value.

    Lastly - if the status is changed back to Active Order (from the Completed Orders sheet) - it should switch again.

    https://docs.google.com/spreadsheets...it?usp=sharing

    Thanks in advance for any help.

  2. #2
    Registered User
    Join Date
    04-23-2007
    Posts
    31

    Re: Google Sheet Rule - Move Record to different Worksheet based on Status Value

    Hi, I have found a solution using the following Google Apps script:

    Please Login or Register  to view this content.
    Here's the tutorial I followed (Thanks Spencer!):
    https://www.youtube.com/watch?v=YBd7Bv41A1Q
    Last edited by antonyx; 01-14-2022 at 11:26 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] compare data in one sheet to others and move cells based on a rule
    By Newbuilder in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-01-2017, 10:51 AM
  2. Replies: 2
    Last Post: 03-07-2017, 04:35 PM
  3. Trying to move a row from one sheet to another based on a cells status
    By stiffanyj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2016, 03:00 PM
  4. [SOLVED] How to move rows of data from one worksheet to another based on date and/or status
    By s0o0y in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-23-2013, 02:26 PM
  5. [SOLVED] Efficiency advice. Finding record status on a sheet to update another sheet.
    By Opy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2012, 09:23 PM
  6. [SOLVED] Move Row to Another Worksheet Once Status is changed
    By cbelle508 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-03-2012, 03:13 PM
  7. Move record from worksheet B to A based on a condition
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-27-2011, 12:48 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