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.