Custom Lists using Numbers

  • Thread starter Thread starter CY
  • Start date Start date
C

CY

I would like to create a custom list that I can use with AutoFill that
consists of numbers (that are employee numbers) but they are non-sequential,
but I need them in a specific order. E.g. 301,304,306,307,309,314,321, so
that if I type 301 the autofill will continue the list for me. Is this
possible?

TIA.

CY
 
Hi CY
This will not be possible with Autofill because your list is made of
numbers.
An alternative would be to amend your employee numbers so that they become
text e.g. EN301, EN304 and so on.
In which case you could use the Tools, Options, Custom lists feature and
create a new custom list from these entries.
See if this helps.

Cordially
Pascal
 
Yep, that's pretty much what I came up with.

Thanks for confirming!

CY
 
Choose Tools>Options
Select the Custom Lists tab
In the List Entries box, type your list of numbers in a column
Click OK
 
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

Autofill Increment a Reference to Another Worksheet 5
Counter-intuitive AutoFill 3
Random number generation 3
When to use delegates? 1
Create a custom fill series or sorting order 1
Concatenate Date and Number field for Append Query 0
Using Drop Down List to Autofill 2
Determine number of rows with data 6

Back
Top