Can Excel autocomplete text from one worksheet and column to another.
Right now all I can get it to do is autocomplete text within the same column.
I have a full workbook and would like to use the data from one worksheet to
the other as well as one column to another.