Results 1 to 3 of 3

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

Threaded View

  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

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