Results 1 to 7 of 7

Find and Copy ONLY Last full Row to Different Workbook Sheet

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2019
    Location
    US
    MS-Off Ver
    365
    Posts
    6

    Question Find and Copy ONLY Last full Row to Different Workbook Sheet

    This copies last row and everything above it but I only want to capture the last row; how do I fix this (or if there's another method altogether, I'm good w/ that too!)

    Need help knowing how to paste it into Sheet 2 of a different workbook too as this only puts it into Sheet2 of same workbook.
    Other workbook would be found here: c:/users/me/Documents/Reports/MasterReport.xlsm (Sheet2)

    I can either have both open at same time when I hit RUN or I can keep the MasterReport closed if that's easier -- whatever is easiest to script..

    Sub CopyLastLinetoNewSheet()
    Sheets("Sheet1").Range("A2:T" & Cells(Rows.Count, "A").End(xlUp).Row).Copy Sheets("Sheet2").Range("A1")
    End Sub
    Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sheet full of formulas, one has a glitch. How to find?
    By vfr700f2 in forum Excel General
    Replies: 2
    Last Post: 11-09-2016, 08:15 AM
  2. Excel not opening workbook to show full sheet.
    By terric2 in forum Excel General
    Replies: 4
    Last Post: 09-12-2013, 11:58 AM
  3. Find name(s) within text string that matches a list, then copy full name
    By juhaszp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2013, 08:48 AM
  4. [SOLVED] If cell is full, copy row to another sheet and workbook
    By pucval in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-21-2012, 08:14 AM
  5. Copy full row then paste to another workbook horizontally last 5 copied cells
    By raemon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2012, 01:41 PM
  6. [SOLVED] On selection, find dups in two colums across workbook, copy duplicates to existing sheet.
    By Joshuarat in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-21-2012, 07:54 PM
  7. Find and Open Workbook then copy and move sheet
    By cwilson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2005, 05:54 PM

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