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.
Bookmarks