Hello oeldere & jindon First thanks for your reply..

oeldere sir... pls send 2003 xls file so that we look your approach ....

jindon sir your provided file work as per my requirement but every time this create a new sheet....
we want only one sheet where data copy i.e. sheet2

pls also tell me about ur code working with comment so that we can easily understand..code..

thanks both of u we also add reputation both of u..