Hi

I want to strip out a list of information in this case a phrase, all from the same worksheet and place them in a different worksheet by category. For example

if the list is like this:

current inflation rate
current UK inflation rate
sipps
uk inflation rate
uk interest rate predictions
alternative energy
gold prices
newspaper articles
price of silver
share prices today
uk interest rate forecast
gold price
buy gold
uk stock market
currency forecasts
HOUSE PRICE PREDICTIONS
HOUSE PRICE PREDICTION

I would want to put all the terms that include gold into one worksheet and those with interest rate into another and so on. I would already have the required worksheets created and named for example gold and interest rate

How would I do this. With a formula or a macro.

Also I would want to strip out/delete the phrase from the original list so I know what to do with the left overs.

If someone knows a formula or macro that would do this I would be most grateful.