How to copy specific rows of filtered data using VB

**Menaka** · 05-01-2013, 05:36 AM

Hi,

I filtered a column using specific criteria, I dont want to copy the whole filtered data, but I want to copy only 2nd and 3rd row of the filtered data to another workbook. Can you please help on that?

I have attached my worksheet with VB code. I filtered column 4 with FilteredBucket1 data, I want to copy column 2 and 3 to anithere work book.

Thanks in Advance,
Menaka B

**arlu1201** · 05-01-2013, 05:50 AM

Do you want to copy 2nd and 3rd row or column? One sentence states column, the other row.

**Menaka** · 05-01-2013, 07:30 AM

sorry its columns oly...2nd and 3rd column

**arlu1201** · 05-01-2013, 09:05 AM

Try this

Please Login or Register  to view this content.

**Menaka** · 05-01-2013, 11:27 AM

Hi,

Thanks for the reply.

It is not copied to the range because in copyFrom.Copy .Range("A" & .Rows.Count).End(xlUp).Offset(1, 0) , I dont have any data in the column. Please take the excel which I attached previously

Can you please check and say why below statement is not returning correct count, if it works I think the code will work fine.

Please Login or Register  to view this content.

Thanks in Advance,
Menaka

**arlu1201** · 05-01-2013, 01:45 PM

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

**arlu1201** · 05-01-2013, 01:46 PM

I used the excel which you gave me and in that i found that the data was being copied to the following ranges ( examples)

A2:B5
C6:D9
E10:F13, etc....