You have already been give an answer to a very similar question in this thread: https://www.msofficeforums.com/excel...ific-data.html. Please don't expect to be spoon-fed. Study the code you've already got to see what changes you might need to make for this situation. If you get stuck, then post back explaining what problems you're having.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I think this macro is different, in anyway I am unable to modify macro, I know I have to learn writing macro. simply if you help with this will be glad. thanks