I have a file with three worksheets it it.
worksheet #1 is a phonebook listing with the lastname in the first column and first name in secon.
worksheet #2 is linked from the first worksheet, but with first name in first column and last name in second.
worksheet #3 is linked from the first and is set up to output as a csv for use on intranet site.
#2 and #3 work, but what I want to do is to have the second sheet sorted by first name, not last. When I do that with the data sort my cells in #2 go blank. I need to be able to add/delete/edit rows and have the data replicate from #1 to #2 and #3.
So far the best I have been able to come up with is to get rid of sheet #2 and make macros to sort #1 by whatever column I want. This could be challenging for some of my users and I would rather have iut as described above.
Hopefully I am describing what I am trying to do. Is this possible and if so what do I have to do to make it work.
Thanks very much.
Bookmarks