Copy last 12 rows after filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to filter some data based on a specific field. However, I need to copy
only the last 12 rows of the filtered data and paste it on another worksheet.
I know how to do all of this in VB except for determining how to only capture
the last 12 rows of the filtered data. I tried getting the last column of
data and setting the copy range from [(last row - 12) to last row] but this
gets the hidden and visible rows instead of 12 of the visible rows.

For ex. lets assume the filtered data is on rows
1,5,10,15,16,24,28,35,40,42,60,72, 75,80. I only need the last 12 so I need
rows 10 ... 80. If I use (last row-12) then it "copies" rows 68 - 80 but
really only captures the data on rows 72 and 80 since the other data between
rows 68 and 80 are hidden.

How can I accomplish this?
 
Get the last row of the destination sheet before you copy to it, then
get it again after you've copied to it to determine how many rows were
copied, then delete all but the last 12 in the destination sheet.

Charles
 
This may be a good approach to my problem. Thanks

Die_Another_Day said:
Get the last row of the destination sheet before you copy to it, then
get it again after you've copied to it to determine how many rows were
copied, then delete all but the last 12 in the destination sheet.

Charles
I need to filter some data based on a specific field. However, I need to copy
only the last 12 rows of the filtered data and paste it on another worksheet.
I know how to do all of this in VB except for determining how to only capture
the last 12 rows of the filtered data. I tried getting the last column of
data and setting the copy range from [(last row - 12) to last row] but this
gets the hidden and visible rows instead of 12 of the visible rows.

For ex. lets assume the filtered data is on rows
1,5,10,15,16,24,28,35,40,42,60,72, 75,80. I only need the last 12 so I need
rows 10 ... 80. If I use (last row-12) then it "copies" rows 68 - 80 but
really only captures the data on rows 72 and 80 since the other data between
rows 68 and 80 are hidden.

How can I accomplish this?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code Snippet - Data Filter 8
Breaking One Row into Multiple Rows using VBA Macro? 2
lastrow function help 6
VBA filter and sorting 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Paste in column B using Last row of either column B, C or D. 10
Converting weekly price data into daily (5 days of the week) format 4
copying cells 2

Back
Top