hi ilses,
indeed ur smaple code helped to reduce the execution time drastically( now its hardly 4-5 secs)
thanks for that.....but if have to check the values in 2 or 3 seperate columns at a time and then copy such rows in which all the three column values are ssatisfied into a new sheet, how...
thx a million....... ilses,
it indeed provided a good start for me n i could achieve the desired result!!!!!
but it takes more than 100 secs to execute the code.....ne suggestionns to improve the speed..
With Regards,
hi all,
i have my data in a excel sheet and now i have to write a vba programme by which a particular columns value is checked in the entire sheetand if it corresponds our condition then the entire row has to be selected and should be appended in new row in another sheet of the work book.
so...
hi all,
i have my data in a excel sheet and now i have to write a vba programme by which a particular columns value is checked in the entire sheetand if it corresponds our condition then the entire row has to be selected and should be appended in new row in another sheet of the work book.
so...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.