I have a list in column A and another list in column B. I need to compare what's in each column and if something's in B but not in A i need to write 'not needed' in column C beside it but if something's in column A but not in column B i need that copied and pasted into column D.

Any suggestions? Is this taking Excel formulas too far and should i be posting in the macro section?

Many thanks
Jo