Thanks in advance for your help.

I have Enable Autocomplete for cell values checked in Options/Edit. If I am
entering in the next blank row in the column that has the text it auto
completes. If i skip a row or go to another column it does not do the auto
complete. Doesn't it look at the entire worksheet when it auto completes?

Thanks,

Sarah