+ Reply to Thread
Results 1 to 6 of 6

Copy Last Row and Paste to Worksheet

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    CDN
    MS-Off Ver
    Excel 2007
    Posts
    135

    Copy Last Row and Paste to Worksheet

    Hi All,

    Can someone help me out with some coding, I've very very new at this.

    Ideal, I'd like a macro to check for the last row of Sheet1 which contains any data, once found, copy and paste it's values into Sheet2, row 8.


    Is this easy to whip up?

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Copy Last Row and Paste to Worksheet

    Please Login or Register  to view this content.
    Last edited by patel45; 10-23-2012 at 11:58 AM.
    If solved remember to mark Thread as solved

  3. #3
    Forum Contributor
    Join Date
    10-03-2012
    Location
    CDN
    MS-Off Ver
    Excel 2007
    Posts
    135

    Re: Copy Last Row and Paste to Worksheet

    Do I define LR as long?

  4. #4
    Forum Contributor
    Join Date
    10-03-2012
    Location
    CDN
    MS-Off Ver
    Excel 2007
    Posts
    135

    Re: Copy Last Row and Paste to Worksheet

    Im very new to this...

  5. #5
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Copy Last Row and Paste to Worksheet

    Quote Originally Posted by Jrub View Post
    Do I define LR as long?
    It's better, but not necessary

  6. #6
    Forum Contributor
    Join Date
    10-03-2012
    Location
    CDN
    MS-Off Ver
    Excel 2007
    Posts
    135

    Re: Copy Last Row and Paste to Worksheet

    Ok Im very confused, how do I work with this to copy and paste the data between sheets?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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