Results 1 to 9 of 9

Loop Range, Copy Cell if Row contains "xyz". Next row...

Threaded View

artvindustries Loop Range, Copy Cell if Row... 10-29-2013, 07:10 PM
JBeaucaire Re: Loop Range, Copy Cell if... 10-29-2013, 08:35 PM
artvindustries Re: Loop Range, Copy Cell if... 10-30-2013, 12:22 PM
artvindustries Re: Loop Range, Copy Cell if... 10-30-2013, 01:06 PM
artvindustries Re: Loop Range, Copy Cell if... 10-30-2013, 06:50 PM
JBeaucaire Re: Loop Range, Copy Cell if... 10-30-2013, 08:09 PM
AB33 Re: Loop Range, Copy Cell if... 10-31-2013, 06:21 AM
artvindustries Re: Loop Range, Copy Cell if... 10-31-2013, 03:56 PM
artvindustries Re: Loop Range, Copy Cell if... 10-31-2013, 12:40 PM
  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    14

    Loop Range, Copy Cell if Row contains "xyz". Next row...

    So i need to Loop a range, well say A3:CZ2000. Header row is 2. If the loops finds "xyz" it copies the header cell in that column.

    Example:

    T17 contains "xyz", T2 is copied and pasted to another worksheet along with a few other cells from that row
    Next loop
    BC24 contains "xyz", BC2 is copied and pasted to another worksheet along with a few other cells from that row


    
        RowCnt = 3
       For Each cell In Worksheets("Sheet 1").Range("A3:CZ2000").Cells
       If Abs(cell.Value) = "xyz" Then Worksheets("Sheet 1").Range(varCol & 2).Copy
       Worksheets("Sheet 2").Range("D10").PasteSpecial Operation:=xlPasteSpecialOperationAdd
       Worksheets .... 'copy a few other cells on that row
       Worksheets .... 'Paste that info to Sheet 2
       Next

    Im at a loss for how to bring all this together
    Last edited by JBeaucaire; 10-29-2013 at 08:33 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to copy into next empty row using "for each cell in range" loop
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2013, 02:30 PM
  2. Replies: 2
    Last Post: 09-12-2013, 10:56 PM
  3. [SOLVED] Loop to check for "yes" then copy the IDs with "yes" and paste to other workbook
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2012, 12:41 PM
  4. Replies: 3
    Last Post: 06-04-2011, 10:56 AM
  5. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 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