Results 1 to 5 of 5

How to copy entire row to a different sheet staring from second column

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    cork
    MS-Off Ver
    Excel 2007
    Posts
    6

    How to copy entire row to a different sheet staring from second column

    Hi All,

    Could you please help me with the below, I can copy the row and paste it but only staring from first column in the new sheet.

    Is there any other way to start pasting from, let's say the second column

    THe code excerpt:


    For counter= 2 To number_rows_check
             
           If Yest.Cells(counter, 3).Value = Db.Range("A4") And Yest.Cells(licznik, 9).Value = Db.Range("B4") And IsError(Yest.Cells(counter, 11)) Then
           
                                       
                        Rows(counter).Copy
                          
                          Comp.Rows(curr_position + 2).PasteSpecial Paste:=xlPasteValues
           
            End If
    
    Next counter
    Thanks for help
    Gregor Olaf
    Last edited by gregorolaf; 09-29-2013 at 01:25 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy the entire row from one sheet to another if column A contains string B
    By roman87 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 10-17-2013, 09:09 AM
  2. If Column U=Yes, copy entire row onto first blank row of new sheet
    By soldevi53 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2012, 05:35 AM
  3. Replies: 1
    Last Post: 02-09-2012, 12:55 PM
  4. If Y in column N, copy&paste entire row into new sheet
    By BSCIEddy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2011, 04:58 AM
  5. Copy entire row to a another sheet if a column value = X
    By jacoolero in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2010, 02:28 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