+ Reply to Thread
Results 1 to 3 of 3

Move a row based on a drop down outcome please help

  1. #1
    Registered User
    Join Date
    02-07-2017
    Location
    Manchester, England
    MS-Off Ver
    OFFICE 365
    Posts
    2

    Move a row based on a drop down outcome please help

    I have attached my spreadsheet to the post.

    Is it possible to move any data row from the "Worksheet" Page with the outcome (FROM COLUMN E) Result being one of (mains,not interested, head office, wrong number) into the "Recycle Sheet" removing it from the "Worksheet" whilst doing so.

    Also if the outcome (Column E) on "Worksheet" Page is "Email" that it moves the row to the "Pipeline" Sheet?

    Any help would be much appreciated

    Nick
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-20-2017
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Move a row based on a drop down outcome please help

    Maybe a better explanation with specific data would be helpful.

  3. #3
    Registered User
    Join Date
    02-07-2017
    Location
    Manchester, England
    MS-Off Ver
    OFFICE 365
    Posts
    2

    Re: Move a row based on a drop down outcome please help

    Basically how this spread sheet will work.

    I Add data for telesales staff to ring through. The new data I add to the "Worksheet" page of the EXCEL File. Each row of data on the page is an individual business with contact details, once they ring the contact they go along the Row to Column E (OUTCOME).

    The "OUTCOME COLUMN" has a drop down menu where they can choose from the following outcomes of the call. At the end of that call they can have one of the following outcomes so they choose either (Lead,Email,Info Found,Mains,Not Interested,Serviced Office,Head Office,Wrong Number,CB,NA,).

    However what i want to do is when they choose any of these from the drop down - (Mains,Not Interested,Serviced Office,Head Office,Wrong Number) I want the row to be deleted off the "WORKSHEET" page and move automatically onto the "RECYCLE LEADS" page

    In addition to this if they choose the outcome (LEAD) I want the row to be deleted off the "WORKSHEET" page and move automatically onto the "LEAD SHEET" Page.

    And lastly If they choose (EMAIL) from the dropdown menu , I want the row to be deleted off the "WORKSHEET" page and move automatically onto the "PIPELINE" Page.

    Is this possible for all these
    Attached Files Attached Files
    Last edited by Nickobrien22; 02-08-2017 at 12:13 PM.

+ 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] Macro to move Entries between Worksheets based on Drop-down Entry
    By PANDACHAN in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-09-2015, 08:50 PM
  2. Move row(s) to a new worksheet based on drop down list value
    By heychandu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2015, 12:26 AM
  3. Move entire row based on drop down selection
    By JamieNick1520 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2014, 08:08 PM
  4. Move active cell based on drop down selection
    By uiucche94 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2013, 03:29 PM
  5. Replies: 9
    Last Post: 01-30-2013, 01:25 PM
  6. Move row to another sheet based on criteria in drop down list
    By cbesinger in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-13-2012, 03:26 PM
  7. Different outcome for drop down box variables
    By Frankiemillion in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-09-2008, 11:32 PM

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