+ Reply to Thread
Results 1 to 3 of 3

Move entire row based on drop down selection

  1. 05-20-2014, 05:23 PM #1
    JamieNick1520
    JamieNick1520 is offline
    Registered User
    Join Date
    04-18-2014
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    5

    Post Move entire row based on drop down selection

    Hi,

    I have a workbook with 3 worksheets. The first 2 worksheets have drop down selections (Recent Changes & General Reminders). I want that when I select "No" in the dropdown, for the ENTIRE row to be copied over into the 3rd worksheet (Punchlist) automatically. Do I need a macro for this? Or is there a forumla? Whatever is easiest would be best!

    Attached is a sample worksheet.

    Thanks!
    Attached Files Attached Files
    Last edited by JamieNick1520; 05-20-2014 at 05:33 PM.
    Reply With QuoteRegister To Reply
  2. 05-20-2014, 07:28 PM #2
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Move entire row based on drop down selection

    Put this code under sheets 1 and 2. I put the enable events lines in just in case you also want to delete the row.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 05-20-2014, 08:08 PM #3
    JamieNick1520
    JamieNick1520 is offline
    Registered User
    Join Date
    04-18-2014
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Move entire row based on drop down selection

    Thank you!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 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
  2. Move data from one worksheet to another based on selection from a drop-down menu
    By SLoumeau in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-30-2013, 01:25 PM
  3. Cut and Paste Entire Row Based on Selection is Hanging when Selection is Not Found
    By therealrichie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 06:00 PM
  4. Move to cell after selection from drop-down list
    By Ray316 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2011, 10:38 PM
  5. possible to move an entire row of cells using result of a drop list?
    By spencermjax in forum Excel General
    Replies: 1
    Last Post: 01-13-2005, 11:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1