Automatic ordering of customers depending on their location

[JokeroDGXx]

Hello !
I am a food supplier in a small town and I have about 200 addresses a day so far everything is written by hand but it is difficult for me already. I want to make it easier to work with an Excel spreadsheet. Automatic ordering of customers depending on their location. For example, I put John who is number 31, and before him is Anna with number 50 and I want John to automatically move over Anna. I searched on Google and I think I should have something like a database with all my clients and their numbers (John 31 .. Anna 50) and the main table to have this property to sort them automatically depending on the date database. I will be grateful if you help me.

[Punnam]

Hi JokeroDGXx ,

Your requirement is not having sufficient data to understand. kindly try to put some information in a sheet along with what is your requirement manually and update sample file here so you could get some help.

Punnam

[JokeroDGXx]

Attachment 678768
I imagine it this way. every time I enter a new person with his corresponding number to automatically rank.the numbers represent the order in which I will go. sorry for my bad english

[Punnam]

Hi,

Some issue with your attachment, i am notable to download it.

Punnam

[JokeroDGXx]

Number Name Milk Feta Cheese Cheese
1 Tony 1 1 1
2 Punnam 1 1
31 John 5 1
4 Trump 3 2 2
50 Anna 1 5 1


Sorry i was trying to insert my excel fail but i cant

[Punnam]

what is your required ouput ?

[JokeroDGXx]

I need it to sort automatically every time I add a new one to the list by number. For example to set the column with numbers to be sorted and after entering a new name it will do it automatically

[alansidman]

See the yellow banner at the top of this page on how to attach a file. Additionally, you have posted in the Access forum. I am moving this to Excel forum.

[Punnam]

Hi,

Is this what you are looking for?

Punnam