- Joined
- Oct 5, 2009
- Messages
- 1
- Reaction score
- 0
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.
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.