ExcelBanter - autocomplete text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - autocomplete text (https://www.excelbanter.com/excel-discussion-misc-queries/31093-autocomplete-text.html)

St. Pats

autocomplete text

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.

All times are GMT +1. The time now is 05:05 AM.