D
DewChugr
I have a file with three worksheets it it.
worksheet #1 is a phonebook listing with the lastname in the firs
column and first name in secon.
worksheet #2 is linked from the first worksheet, but with first name i
first column and last name in second.
worksheet #3 is linked from the first and is set up to output as a cs
for use on intranet site.
#2 and #3 work, but what I want to do is to have the second shee
sorted by first name, not last. When I do that with the data sort m
cells in #2 go blank. I need to be able to add/delete/edit rows an
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 shee
#2 and make macros to sort #1 by whatever column I want. This could b
challenging for some of my users and I would rather have iut a
described above.
Hopefully I am describing what I am trying to do. Is this possible an
if so what do I have to do to make it work.
Thanks very much
worksheet #1 is a phonebook listing with the lastname in the firs
column and first name in secon.
worksheet #2 is linked from the first worksheet, but with first name i
first column and last name in second.
worksheet #3 is linked from the first and is set up to output as a cs
for use on intranet site.
#2 and #3 work, but what I want to do is to have the second shee
sorted by first name, not last. When I do that with the data sort m
cells in #2 go blank. I need to be able to add/delete/edit rows an
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 shee
#2 and make macros to sort #1 by whatever column I want. This could b
challenging for some of my users and I would rather have iut a
described above.
Hopefully I am describing what I am trying to do. Is this possible an
if so what do I have to do to make it work.
Thanks very much