E
Eric
Dear Boardmembers,
I have a collection of data with headings across the top
of the worksheet like this.
Date IDNumber Name Place and so forth
entry 1---------------
entry 2---------------
and so forth
There are filters for each column. And I would like to be
able to sort/re sort/filter for Date or IDnumber etc.
(column) while protecting the integrity of each entry
(row). So that a sort for IDNumber descending returns not
just sorted IDnumbers but complete intact rows, sorted by
IDnumber. Is there an easy way to "lock" each row of data
in this fashion? Thank you for your help.
I have a collection of data with headings across the top
of the worksheet like this.
Date IDNumber Name Place and so forth
entry 1---------------
entry 2---------------
and so forth
There are filters for each column. And I would like to be
able to sort/re sort/filter for Date or IDnumber etc.
(column) while protecting the integrity of each entry
(row). So that a sort for IDNumber descending returns not
just sorted IDnumbers but complete intact rows, sorted by
IDnumber. Is there an easy way to "lock" each row of data
in this fashion? Thank you for your help.