Hey excel gurus,
I recently acquired knowledge about using the built-in autocomplete feature in excel. It is very handy dandy tool. I have currently a list of less than 200 company names with me which I would like to auto-complete to save the time. I will type the company's names starting from row 301. Keeping 100 spare rows in between just in case the list will get any bigger. The formula which goes in row 2 till 300 is
=IF('Data Validation List'!F2=0,"",'Data Validation List'!F2)
The Data Validation List is my sheet name and the company's names start from column F2. This is then copied down all the way up til row 300 of my other sheet.
Now coming to the title of this thread. I learned that hitting backspace five times before typing anything in a cell will boost the auto-complete feature. Is there a code for when alphabet key is hit for the very first time after sheet selection change, then trigger 5 backspaces, prior to entering the pressed alphabet key?
For instance the user hit S and the code triggers 5 backspaces and then types S
Thank you.
I recently acquired knowledge about using the built-in autocomplete feature in excel. It is very handy dandy tool. I have currently a list of less than 200 company names with me which I would like to auto-complete to save the time. I will type the company's names starting from row 301. Keeping 100 spare rows in between just in case the list will get any bigger. The formula which goes in row 2 till 300 is
=IF('Data Validation List'!F2=0,"",'Data Validation List'!F2)
The Data Validation List is my sheet name and the company's names start from column F2. This is then copied down all the way up til row 300 of my other sheet.
Now coming to the title of this thread. I learned that hitting backspace five times before typing anything in a cell will boost the auto-complete feature. Is there a code for when alphabet key is hit for the very first time after sheet selection change, then trigger 5 backspaces, prior to entering the pressed alphabet key?
For instance the user hit S and the code triggers 5 backspaces and then types S
Thank you.
