Results 1 to 7 of 7

Move rows if cell have value from a list

Threaded View

origal Move rows if cell have value... 11-18-2015, 06:19 AM
jindon Re: Move rows if cell have... 11-18-2015, 07:50 AM
origal Re: Move rows if cell have... 11-18-2015, 08:19 AM
jindon Re: Move rows if cell have... 11-18-2015, 08:24 AM
origal Re: Move rows if cell have... 11-18-2015, 08:37 AM
jindon Re: Move rows if cell have... 11-18-2015, 08:56 AM
origal Re: Move rows if cell have... 11-18-2015, 09:00 AM
  1. #1
    Registered User
    Join Date
    04-10-2015
    Location
    Manchester, England
    MS-Off Ver
    2013
    Posts
    11

    Move rows if cell have value from a list

    Good morning all,
    I'm trying my luck again :-)

    I have a document with 3 sheets:
    Sheet 1 - Full Database
    Sheet 2 - List of Specific values that I want to move from the database into (Sheet 3)
    Sheet 3 - The relevant values from Sheet 1 (database) that matched the index in Sheet 2.

    I'm looking for a macro that will move rows from Sheet 1 to Sheet 3 based on the list of values in Sheet 2.

    For example:

    Sheet 1:
    A--------------B
    Dave----------1
    Darren--------2
    Tom-----------2
    Sarah---------3
    Michael-------4
    Robin---------5
    Daniel--------5
    Ron-----------6

    And Sheet 2:
    A
    1
    3
    5

    Sheet 3:
    Dave----------1
    Sarah---------3
    Robin---------5
    Daniel--------5

    In sheet 3 I want to have only the rows from sheet 1 that are in the list in sheet 2.
    Please find the document attached.

    Thanks!

    Ori

    ExampleD.xlsm
    Last edited by origal; 11-18-2015 at 06:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to move code to cell, print, then move down the list to the next code
    By MilesDeep in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2014, 04:59 PM
  2. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  3. Move multiple rows into one cell
    By mundo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2013, 10:46 AM
  4. [SOLVED] Move all rows where cell = "complete" to the bottom of the list
    By floribunda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2013, 03:25 PM
  5. 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
  6. programatically move through a validation list cell
    By dieffen in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-24-2010, 03:11 AM
  7. how can i move a list button into a cell
    By mikejhenderson in forum Excel General
    Replies: 0
    Last Post: 03-16-2006, 10:35 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