+ Reply to Thread
Results 1 to 4 of 4

Select last row in column A and select 49 rows up, copy results to A2

  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Select last row in column A and select 49 rows up, copy results to A2

    Hi everyone,

    I have a data sheet with a variable range. What I'm trying to do is find the last row in column A, select 49 rows up (including the last one already found) and paste the those 49 rows of data starting at cell A2.

    Any ideas?

    Thanks!

  2. #2
    Registered User
    Join Date
    12-22-2015
    Location
    Huntsville, AL
    MS-Off Ver
    2007
    Posts
    92

    Re: Select last row in column A and select 49 rows up, copy results to A2

    I'm having trouble envisioning this.

    You have a range in column A (presumably that starts in A1?).

    You want to go to the last entry in column A, select 49 rows up, and paste those 49 rows, in A2.

    Why 49 rows?

    You write "including the last one already found". The last what that was already found?

    Can you provide a sample workbook and some clarity as to what exactly you're trying to accomplish?

  3. #3
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Select last row in column A and select 49 rows up, copy results to A2

    Try

    Please Login or Register  to view this content.
    Martin

  4. #4
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Select last row in column A and select 49 rows up, copy results to A2

    Thank you Mrice

+ 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. Replies: 9
    Last Post: 11-20-2015, 04:20 AM
  2. [SOLVED] How to select filtered values and copy the results using makros
    By chablo309 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2015, 09:34 AM
  3. How to select filtered values and copy the results using makros
    By chablo309 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2015, 09:14 AM
  4. [SOLVED] Select Case Code for Column A Values to Populate Results in Column B in Same Row
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2014, 05:22 PM
  5. Code to prevent user to Select COLUMNS but allow to select ROWS
    By tengrosita in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2011, 03:46 AM
  6. Using VBA to autofilter and paste over results - can't select only filtered rows.
    By Cornwell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2010, 11:33 AM
  7. Replies: 1
    Last Post: 04-23-2007, 04:23 PM

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