thanks for your code.

the code is copying from one sheet to another row wise.that is ok .

please let us know the code also for copying from one sheet to another
column wise in which word "aged" and or "independent" found .

ramesh

*** Sent via Developersdex http://www.developersdex.com ***