+ Reply to Thread
Results 1 to 3 of 3

Copy a specific row and a range of columns to next available row on another worksheet

Hybrid View

  1. #1
    Registered User
    Join Date
    11-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Copy a specific row and a range of columns to next available row on another worksheet

    Hi

    I am trying to copy a specific row number with a range of columns to the next available row on another worksheet.

    This is what I have right now:

    For timeKeeper2 = 2 To counter6 - 1
                If Worksheets(3).Cells(timeKeeper, 19) = "" Then
                
                Worksheets(3).Range(timeKeeper2, "B10:E10").Select
                Selection.Copy
                Worksheets(Worksheets(3).Cells(timeKeeper, 1).Text).Activate
                Worksheets(Worksheets(3).Cells(timeKeeper, 1).Text).Range("A" & Rows.Count).End(xlUp).Offset(1).Select
                ActiveSheet.Paste
            End If
    Next
    However, it does not seem to know where I am referencing. Anyone have ideas on how to solve this?

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: Copy a specific row and a range of columns to next available row on another worksheet

    Hello,

    Difficult to test without seeing your workbook...
    Something like this maybe :

    For timekeeper2 = 2 To counter6 - 1
       With Worksheets(3)
          If .Cells(timekeeper, 19) = "" Then
             .Range("B" & timekeeper2).Resize(1, 4).Copy Sheets(.Cells(timekeeper, 1).Text).Range("A60000").End(xlUp).Offset(1, 0)
       End With
       
    Next timekeeper2
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Registered User
    Join Date
    11-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Copy a specific row and a range of columns to next available row on another worksheet

    Basically I think I can get it I know how to reference a specific row with a range of columns.

+ 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 worksheet with specific name and no blank cell in a specific range
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-05-2013, 11:50 AM
  2. Replies: 3
    Last Post: 06-17-2013, 06:00 AM
  3. [SOLVED] Getting Unique Value, copy specific columns to another worksheet
    By EXCEL0429 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2013, 09:02 PM
  4. copy specific range of rows and columns according to a cell value
    By archangel9999 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2013, 03:41 PM
  5. Copy several columns and paste into specific column on another worksheet
    By lcy_84 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2012, 09:19 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