W
Wilfried Hennings
Hello all,
table on sheet 1 consists of (say) a row with names and a row with room
numbers and is sorted by name. (First row is header and not included in
sorting.)
I want to create a copy of this table on a second sheet containing the
same data sorted by room number which automatically re-sorts when the
data in the first table is changed.
I could think of a matrix function but could not find any.
Any idea?
--
email me: change "nospam" to "w.hennings"
Dipl.-Ing.(=M.Sc.Eng.) Wilfried Hennings c./o.
Forschungszentrum (Research Center) Juelich GmbH, MUT
<http://www.fz-juelich.de/mut/index.php?index=3>
All opinions mentioned are strictly my own, not my employer's.
table on sheet 1 consists of (say) a row with names and a row with room
numbers and is sorted by name. (First row is header and not included in
sorting.)
I want to create a copy of this table on a second sheet containing the
same data sorted by room number which automatically re-sorts when the
data in the first table is changed.
I could think of a matrix function but could not find any.
Any idea?
--
email me: change "nospam" to "w.hennings"
Dipl.-Ing.(=M.Sc.Eng.) Wilfried Hennings c./o.
Forschungszentrum (Research Center) Juelich GmbH, MUT
<http://www.fz-juelich.de/mut/index.php?index=3>
All opinions mentioned are strictly my own, not my employer's.