Copying Rows to to another Sheet based on the column data?

Hi,


I had a requirement of copying the column data from sheet to another sheet in excel based on the condition. I am able to copy the single row but i am not able to do the same. I am new to excel VBA. so i planned for an algorithm as
1. Iterating rows using for loop
2. Checking the condition of the particular column value


but i am not acheive the code as above mentioned steps, and i dont know whether it hits the prformance. I had many rows nearly above 30k. so could anyone please suggest me the answer for this

I attached an sample excel sheet

Hi BhuvanRam

The following code should be pasted in to the Macro sheet for Sheet2. Do do this, open the VBA Editor and double click Sheet2 on the left hand side.

It will run every time that sheet is activated.

Please Login or Register  to view this content.

Best regards, Rob.

Hi,

Thank you for the Answer. But the problem is its taking so much of time to copy , because i had 65 Columns and 35000 Rows nearly. Do we have any other way to do it? And is it possible to copy the rows by leaving one row blank as offset(2,1)?

thanks
bhuvan