Conditional Copy & Paste

[Victor Lim]

Hi,
I am a beginner in Excel Macro development. Got an example if you can help.

I have a list of symbols and its respective names in the worksheet "WatchList". I want to copy & paste the symbol and name (Col C & Col D) to worksheet "Selected List" when the selection condition stated in Col B & Col C of "Watchlist" is "Yes". However, when a new symbol and name is entered in "WatchList" to replace one of the existing symbol & name and the condition is also "Yes", the macro will copy the new symbol & name into "Selected List" but will just add on to the list without removing the previous name. This way, I will have the history of the selected names in "Selected List".

Thanks in advance

Victor