View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach
 
Posts: n/a
Default Major Sorting Problems!!!

Hodak
You say that you have the first 3 rows merged and that you don't want to
unmerge those first 3 rows in order to sort. Let me ask you this: Do you
want those first 3 rows included in the sort? If you don't, then a simple
macro can be written to sort everything below those 3 rows and to sort on
the column that the user clicks on. Post back and clarify what you want
done with those 3 rows. HTH Otto
"Hodak" wrote in message
...
I am working on a major spreadsheet for a client and I have the first 3
rows
of the spreadsheet merged. We do NOT want the client to have to highlight
the
whole spreadsheet just to sort it. This spreadsheet is VERY important! Is
there any way that they could just click on one column and sort the
spreadsheet without unmerging the cells?