Hi and I would appreciate any help I can get on this. I have a
worksheet with 3 columns. The header row is: Name, Employee # and
Extension #. The data and number of rows changes frequently as we move
and add new employees. I need to be able to enter the info once (on
one sheet) whenever it changes and allow users to sort the data by each
column (Empl name, Ext. # & Empl #). Sounds easy enough, except I am
designing it as a web page that users can view in a browser because
they don't have excel on their pc's. I don't want to allow
interactivity because I don't want users to change the data. I need to
know the best way to accomplish this. Can I do this with one worksheet
or do I need a separate worksheet for each sorted list? Employee name
and Employee # are always matched, so vlookup can be used to get
adjacent data, but how do I get it automatically sorted once I update
the master sheet? Thanks for any help.