+ Reply to Thread
Results 1 to 4 of 4

Moving a Row of Data from one sheet to another based on criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    12-05-2010
    Location
    Tijuana
    MS-Off Ver
    Excel 2010
    Posts
    10

    Moving a Row of Data from one sheet to another based on criteria

    Hello all,

    I was hoping I could get some help. So I have a file where I want to move a complete row of data onto worksheet "Salidos" is there is an "s" typed into that
    row's "Salido" column. I saw several examples of similar questions online but I just can't keep up with them! I've attached an image for your reference.

    Help pretty please!!!


    Excel.png

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Moving a Row of Data from one sheet to another based on criteria

    Do you want that row moved when someone types an "s" in that column, or do you want the code to scan the whole column and move all the "s" rows over together?
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Registered User
    Join Date
    12-05-2010
    Location
    Tijuana
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Moving a Row of Data from one sheet to another based on criteria

    Hello there, I want that row moved when someone types an s in that column. Also if the row space (blank) left after the data is moved could be deleted, that would be great!!

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Moving a Row of Data from one sheet to another based on criteria

    Can you provide a sample sheet showing your layout? I'm confused about Salidos Column.

+ 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. Moving a row to another sheet based on two cells criteria
    By kain6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2016, 05:02 PM
  2. [SOLVED] Moving Rows to different sheet based on cell criteria
    By SpreadsheetNublet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2015, 03:12 PM
  3. moving data from one sheet to another based on criteria
    By premis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2013, 12:50 PM
  4. [SOLVED] need help moving info from one sheet to another sheet based on criteria
    By MariahD24 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-24-2012, 03:20 AM
  5. Moving rows of data to a new sheet based on date criteria
    By kaufmann98 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2012, 01:41 PM
  6. [SOLVED] Moving rows to a different sheet based on yes/no criteria
    By mpc_2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-25-2012, 06:01 AM
  7. Moving data to another sheet based on criteria
    By jantonio in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2009, 12:24 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