Hi,

I have a list of quotes that I keep expanding everyday. I want to create a checklist of keywords so that everytime I enter a new quote, I can check the keywords relevant to the quote.

Is there any way that, every time I enter a new quote (say in column B), the same checklist will be displayed in column C?

Also how can I display everything that has been checked for a particular quote be displayed in a single cell? (e.g. in column D, it will show up as agriculture, food, technology)

Many thanks for your help,
HHMG