+ Reply to Thread
Results 1 to 2 of 2

Move row from one sheet to another based on dropdown selection

  1. #1
    Registered User
    Join Date
    11-30-2017
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    1

    Move row from one sheet to another based on dropdown selection

    Hello! Newbie alert. Ive been trying to create a spreadsheet that allows us to track enquiries through to proposals and then live projects.

    See attached spreadsheet for the basics.

    In short, i'd like to move the information in one row to another sheet once a specific dropdown value is selected., Ive seen loads of examples of this but for some reason i cant seem to get it to work on my spreadsheet.

    I have 5 worksheets as follows

    Enquiries
    Proposals
    Live Projects
    Closed Projects
    Rejected

    I want to be able to move rows from one sheet to another by selecting the relevant choice in a dropdown. My dropdown choices are as follows:

    Enquiry Open
    Enquiry Rejected
    Proposal Sent
    Proposal Rejected
    Project Live
    Project Closed

    I've tried the following:

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Column = 10 Then
    If Target = "Enquiry Rejected" Then
    Application.EnableEvents = False
    nxtRow = Sheets("Rejected").Range("I" & Rows.Count).End(xlUp).Row + 1
    Target.EntireRow.Copy _
    Destination:=Sheets("Rejected").Range("A" & nxtRow)
    Target.EntireRow.Delete
    End If
    End If
    Application.EnableEvents = True

    End Sub

    But im not getting any joy.

    Can anyone help with this? It's doing my head in!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Move row from one sheet to another based on dropdown selection

    Possibly a little simpler code.
    Please Login or Register  to view this content.

+ 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 row to another sheet based on drop down selection
    By Charge124 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-03-2017, 11:35 AM
  2. [SOLVED] Move Row to Another Sheet Based on Dropdown Value
    By Mathias25 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-02-2017, 02:10 AM
  3. Move Row to Another Sheet Based on Dropdown Value
    By kim.wo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2016, 12:10 PM
  4. Replies: 11
    Last Post: 05-23-2016, 07:06 PM
  5. Move to a particular Sheet based on the selection criteria
    By soumendu_bose in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2015, 12:46 PM
  6. Replies: 1
    Last Post: 01-17-2014, 04:00 PM
  7. Modify formulas on the entire sheet based on dropdown selection
    By robolist in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2013, 07:22 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