Hi Paul

Thanks for the reply.

If any para exist in the "PV" cell, how to retain that para without deleting that one?

Also, the excel data that i provided sometimes protected. So, is there any possible to detect the values from the drop down in the word based on the excel data instead of copy (ex., Esy=1-Easy etc...) from the excel (using "case" option).

Please advise.

thanks again
ganesang