+ Reply to Thread
Results 1 to 2 of 2

Select row based on condition and copy to other different sheet.

  1. #1
    Registered User
    Join Date
    11-16-2016
    Location
    tilburg
    MS-Off Ver
    2013
    Posts
    1

    Select row based on condition and copy to other different sheet.

    Hi all,

    I am looking for an VBA code to transfer all rows with status in column T "Ja" to the next open line in the next work sheet. Could you please help me out!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: Select row based on condition and copy to other different sheet.

    Hello Allard6,

    I tried the following code in your sample work book and it worked just fine:-


    Please Login or Register  to view this content.
    I hope that this helps.

    Cheerio,
    vcoolio.

+ 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. [SOLVED] Copy data from one excel sheet to another based on condition
    By Dorababu in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-02-2015, 07:12 AM
  2. Need a macro to copy data from one sheet to another based on condition.
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2013, 01:56 AM
  3. Copy row to another sheet based on a condition
    By ltf09a in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2012, 11:55 PM
  4. select a column range based on a condition and copy to another sheet
    By GSCCK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2012, 10:59 PM
  5. Select worksheet based on condition & populate cell based on condition
    By beth1069 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 01:27 PM
  6. Copy/Paste from one sheet to another based on condition
    By TheTempest in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-16-2010, 01:13 PM
  7. select certain cells based upon condition and putting in sheet 2
    By jazbath in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-26-2009, 03:03 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