Autocomplete doesn't work between pages in the same worksheet

[Ramadan]

I have 02 issues with autocpmplete.... first - I have a worksheet with multiple pages (alomst 30 pages) and autocomplete only work in the current page but when I scroll down to insert data in a new page it doesn't work

second - another worksheet with a table and I have 4 coulmn where i insert name of engineers but autocomplete only pick up the name if it's found in the same column but not from other columns.. for example if I'm inserting name in "A" and this name is already found in "C", autocomplete doesn't pick it up unless if it's repeated in "A"

please help me how to fix that even with a vba code

 

[Peter_SSs]

but autocomplete only pick up the name if it's found in the same column

That is just how autocomplete works. It works in a single column with continuous data.

 

[jkpieterse]

Have you considered using Data Validation, List option?

 

[Ramadan]

Have you considered using Data Validation, List option

I don't have a fixed list to do so, there is always new names

 

[jkpieterse]

You can have the list of names update itself as new are added