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!
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!
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?
Try
Please Login or Register to view this content.
Martin
Thank you Mrice
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks