Basically what i want it to do is... I have a list of keywords in 1 column. I want the macro to prompt me for an entry (keyword) and then it will pull out all cells that contain this keyword and put it in another column. So..if I have a list that looks like this (my keyword is milk): it will prompt me for a keyword (milk): milk cookies milk and cookies milk and cream food food store it will pull out: milk, milk and cookies, milk and cream into a separate column. thanks!