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
Bookmarks