Hi All
On Sheet 1 in my workbook , each entry in columns F , G and H auto-completes once a few entries have been made in each column. Excel learns from the earlier entries to make suggestions for subsequent entries.
On Sheet 2 , it seems that all of the learning has to start again and no auto-complete data is taken from Sheet 1.
How can I have auto-completion carry over between sheets in the same workbook , rather than start again with each worksheet?
Grateful for any advice.
Bookmarks