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
Bookmarks