+ Reply to Thread
Results 1 to 2 of 2

Paste into bottom of data set

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-06-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    225

    Question Paste into bottom of data set

    I am trying to copy data from a column in a worksheet, and paste it into column “A”, at the bottom of a data set in another worksheet (“Final Report”). So there will be a bunch of data, then a title bar, then I want the copied data to be pasted in column “A” underneath the title bar. Both worksheets are in the same workbook.

    I have the filtering and copying down, just need to know how to get the cursor to paste the data in the proper place.

    Below is what I have so far:

    ActiveSheet.Range("$A$1:$JE$1332").AutoFilter Field:=57, Criteria1:="=”
        ActiveSheet.Range("$A$1:$JE$1332").AutoFilter Field:=85, Criteria1:="="
       lr = Cells(Rows.Count, 1).End(xlUp).Row
       With Range("U2:U" & lr)
    .SpecialCells(xlCellTypeVisible).EntireRow.Copy ActiveSheet.Range("A" & Rows.Count).End(3)(2)
       
        End With
        Sheets("Final Report").Select
    ....

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Paste into bottom of data set

    Is this solved?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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