Greetings list--
An employee of the agency for which I provide network and user support
has apprised me of a problem with sorting work order data in a multi-sheet
Excel workbook. The computer is a P4 1.6 GHz, 128 RAM, 10GB Hard
Disk desktop by Gateway, and it is networked with 9 other client computers
in a Win NT 4.0 server environment.
The symptoms of the problem are as follows:
All sheets of the workbook have the same row 1 column names and, on a sort,
the first row is indicated as a header row.
As it is a work order tracking tool, start date and end date are two of the
columns.
As might be expected, not all cells are filled in with completion dates.
The employees using the spreadsheet were "savvy" enough to put house
numbers after street names to facilitate sorting data to find a given
order.
When the entire worksheet is selected, and a data sort is initiated by
street
name (with the first row indicated as a header row) the sheet *seems* to
sort.
What happens, though, is that data in cells (I'm speculating here, as I
didn't
create it) with 'general' number formatting is sorted, but the cells
formatted
as 'date' do not sort, i.e., a completion date will be associated with what
was
formerly a job with a blank cell in that column.
Is there something this individual is missing in sorting or formatting
which
makes this sort fail to rearrange complete rows based on the chosen
sorting column?
If anyone has an idea how to fix this, please let me know.
I'd sure like to look like an Excel lizard, er.... wizard, as well as the
"computer and network mechanic."
TIA.
Paul A. Shippert
Library Media Specialist
Margaret Brent Middle School
---------------------------------------------------------------------------
-----
"and I'm hovering like a fly,
waiting for the windshield on the freeway." Genesis
---------------------------------------------------------------------------
-----
The NOSPIN Group Promotions is now offering
Mandrake Linux or Red Hat Linux CD sets along
with the OpenOffice CD... at a great price!!!
http://freepctech.com/goodies/promotions.shtml
|