I have a sheet of 6 columns. I want excel to sort automatically the
first two columns. The first column is Names and the second is an
item number. Since this is an inventory sheet, i will have several of
the same name in the first column, but the second column will never
have a repeating number. When i enter new data, is there a way for
excel to automatically place the new entry into its appropriate spot
alphabetically. Right now, i have to sort the item number column,
then the name column in order to achieve the effect that i want. I
know of the sort button, but if someone other than myself enters the
data there could be a problem. i work with people that need things as
simple as possible, or they will find a way to screw it up. ne help
would be appreciated.