+ Reply to Thread
Results 1 to 3 of 3

Unable to get rows to move to other sheets with VBA based on cell drop down text entry

  1. #1
    Registered User
    Join Date
    01-09-2015
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    2

    Unable to get rows to move to other sheets with VBA based on cell drop down text entry

    Hello,

    I have a worksheet that I am using to track which of our quotations are in a status of "Active", "Stale", "Lost", "Submitted" or "Accepted". These statuses are stored in the "References" tab and can be selected via a drop down menu on the main "Quotation_Register" tab. Up until now, I have employed conditional formatting with a color coded scheme that allows me to easily identify which rows fall under which condition (other than Active or Submitted, which need to remain in the "Quotation_Register" sheet until they are either lost, stale or Accepted) and then manually cut and paste the "Stale", "Lost" and "Accepted" quotations to their relevant tabs: "Stale_Quotations", "Lost_Quotations" and "Works_in_Progress" respectively. I would like to automate this so that once one of those 3 last statuses is selected, that entire row will auto cut and paste to the next available free line on the relevant tab and the then empty rows on the "Quotation_Register" tab will be removed. I have attempted quite a few solutions as outlined by other members in similar threads on a number of sites, including this one. Unfortunately, I have been unsuccessful in getting this to work at all. I have even tried rearranging my template to match the code, but also, without success. I hope I have adequately described my problem and have complied with the rules for thread posting. I would greatly appreciate any help from fellow members. I have attached a clean copy of the register for further clarity. Many thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Unable to get rows to move to other sheets with VBA based on cell drop down text entry

    This seems to work. Copy to standard module.
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    01-09-2015
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    2

    Re: Unable to get rows to move to other sheets with VBA based on cell drop down text entry

    Thank You Tinbendr

    Works like a charm.

    Many, many thanks - very much appreciated.

+ 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. move rows to new sheet based on text and date in multiple sheets
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2014, 02:39 PM
  2. 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
  3. Restrict entry in various cells based on drop down choice in another cell
    By Stretch617 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2013, 04:09 PM
  4. Insert Rows Based on text Box Entry in User Form
    By aqhibjaveed2183 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 02:44 AM
  5. Replies: 3
    Last Post: 11-08-2012, 07:25 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