On the "Data List" worksheet, the user right-clicks on any column on the row
that contains the data they want to process.

My code picks up several pieces of information and writes it on the
"Worksheet" worksheet.

So far, so good.....However......

Column K on the "Data List" worksheet may or may not contain a comment for
the specific item.

If a comment exists, I would like to: (1) Add the commet to cell (K9) on the
"Worksheet" worksheet and (2) Add "Yes" to cell (K9) on the "Worksheet"
worksheet also.

If there is no comment then I would like to add "No" to cell(K9) on the
"Worksheet" worksheet.

I've seen code that will copy all of the comments on one sheet to another
and have tried to modify that to do what I want but I'm having trouble with
that. Any suggestions or code to accomplish this would be greatly
appreciated.

Thanks for the help.....
--
JT