Using autocomplete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using excel to log in customer payments. How can I get autocomplete to
complete customer names so I won't have to type them over and over? Is there
a place I can create a data base of the name? Thanks
 
The only way Excel Autocomplete works is if the value has previously been
entered into the same column, and there are no blank cells between the
values (database) and values that you enter now. So you'd have to do a dirty
little workaround...
*******************
~Anne Troy

www.OfficeArticles.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down list autocomplete 6
Autocomplete combo box 5
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
Autocomplete from a list on the worksheet 3
Autocomplete 1
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
autocomplete from specific list 8
Amazon not accepting Visa Credit Card for payment from January 2022 20

Back
Top