Ramadan2512
New Member
- Joined
- Sep 7, 2024
- Messages
- 31
- Office Version
- 2021
- Platform
- Windows
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
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