Forum Discussion
How to autocomplete across sheets
Hi all,
Whenever I type on an excel sheet, it will autocomplete a name if I have already used it before. I was wondering if it was possible to make this happen across multiple sheets? For example, if I use the name John Doe in Column A on sheet one, is there a way to get it to autocomplete the same name in Column A on sheet 2?
Thanks!
3 Replies
Afraid not, autocomplete works on the same column. If only don't use some VBA tricks like this http://www.vbaexpress.com/kb/getarticle.php?kb_id=244
SergeiBaklan If I took the data from sheet one and added it to sheet two then hid those rows, would it be possible for autocomplete to be triggered from both the hidden and unhidden rows on that sheet?
Yes, hiding of rows doesn't affect autocomplete. You may do small test yourself.
