Thank you 6StringJazzer. That's the kind of solution I'm after however when I enter something into column E and go to select a cell in column A to enter the next name, Excel hangs (not responding). Any ideas why this might be please?