[Heights_Pavel]

Hello,

I would like to create a spreadsheet that will automatically sort itself when new data is entered.
Currently I have 9 columns, column A being the one with the identifying code for sorting.
The code used for sorting consists of two or three letters followed by four numbers (i.e.AB1234).
Is there a way to make this happen?
Also,I was wondering if there was a possibility of automatically updating copies of this spreadsheet when I make a change to it. That is, let's say I have a Master Contact List spreadsheet on my computer and my coworkers have copies of that list on their computers (everyone is connected to the same network). Is there a way to make a change to the Master List and have that info be updated on the copies without having to copy it manually?

Thanks so much.