+ Reply to Thread
Results 1 to 6 of 6

Copy rows from active sheet to another sheet (last row) if condition in column X is met

  1. #1
    Registered User
    Join Date
    09-16-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    6

    Lightbulb Copy rows from active sheet to another sheet (last row) if condition in column X is met

    Hi to all smart guys over here.

    Straight to the point: I need a simple macro (excel 2010) that will copy all rows (range (A-I)) from active sheet that contains "a" in column "J" to another sheet last row. In addition I need content of cell C4 (active sheet) to be copied to column A for all copied rows in destination sheet.

    Doable?

  2. #2
    Registered User
    Join Date
    09-29-2011
    Location
    Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Copy rows from active sheet to another sheet (last row) if condition in column X is me

    Hi Mortless, can you clarify what you mean by: "copy all rows (range (A-I)) from active sheet that contains "a" in column "J" to another sheet last row" - do you mean the next unpopulated row?

  3. #3
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Copy rows from active sheet to another sheet (last row) if condition in column X is me

    Not exactly sure what you're looking for but maybe:
    Please Login or Register  to view this content.
    Untested
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  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: Copy rows from active sheet to another sheet (last row) if condition in column X is me

    Maybe:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-16-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Copy rows from active sheet to another sheet (last row) if condition in column X is me

    Quote Originally Posted by Solus Rankin View Post
    Not exactly sure what you're looking for but maybe:
    Please Login or Register  to view this content.
    Untested

    As this one works very nice, here comes the tricky part. Would it be possible at the same time to create a link (mirror), so all new copied cells where linked back to its source? Means, when you make a change to a new copied cell the same change will appear in the source cell?
    The thing is, rows are copied from many tabs (named 1,2,3,4,5...).

    I have posted a new thread on this:

    http://www.excelforum.com/excel-prog...html?p=3408731
    Last edited by mortless; 09-17-2013 at 07:20 AM.

  6. #6
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Copy rows from active sheet to another sheet (last row) if condition in column X is me

    If you are happy with the solution, please mark this thread as solved and we can continue on the new thread.

+ 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. Copy rows in a new sheet with a condition
    By Brett Mercier in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2013, 11:07 AM
  2. Replies: 1
    Last Post: 01-07-2013, 12:23 AM
  3. Macro to Copy Rows with Certain Condition to another Sheet?
    By rorybecers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-24-2011, 09:15 AM
  4. Delete Rows that contains zero and Copy active sheet to New Sheet
    By antoni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2009, 02:02 AM
  5. Copy from active sheet and paste into new sheet using info from cell in active
    By Ingve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2006, 06:00 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