+ Reply to Thread
Results 1 to 2 of 2

Move row(s) to a new workbook based on cell content

  1. #1
    Registered User
    Join Date
    11-06-2018
    Location
    England
    MS-Off Ver
    2010
    Posts
    1

    Move row(s) to a new workbook based on cell content

    Hi all,

    I am a total beginner when it comes to VBA and i was wondering if it is possible to do the below with a macro? I want to be able to move any rows where the first cell of that row that contains a certain piece of text gets moved into a new workbook.

    For example any row where the first cell contains the word "Excel" gets moved into a new workbook. I can then alter the macro for any other word that I need to look for.

    The most I have atm is the ability to move the active row (but only a single row) to a new line, that is unfortunately the limit of my VBA knowledge.

    I apologize as I know this is a terrible explanation but hopefully you guys get the idea
    Last edited by CMason87; 11-06-2018 at 12:25 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,285

    Re: Move row(s) to a new workbook based on cell content

    Maybe like this
    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. Replies: 0
    Last Post: 06-19-2014, 04:20 PM
  2. VBA Code- Move/Split cell content based on ","
    By Langer101 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-19-2012, 11:37 AM
  3. Move ranges from workbook to workbook based on cell value
    By SLIDE1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-05-2012, 10:45 PM
  4. copying cell content into a specific workbook based on the content in that cell
    By krishna reddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2012, 03:52 AM
  5. move rows based on cell content and add header
    By reggie1000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2009, 03:05 AM
  6. Importing Data From another workbook based on cell content
    By xxchrisukxx in forum Excel General
    Replies: 1
    Last Post: 08-16-2007, 06:44 AM
  7. Replies: 2
    Last Post: 12-19-2006, 10:50 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