Major Sorting Problems!!!

[Guest]

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?

 

[Otto Moehrbach]

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

 

[Guest]

No, I do not want the 3 rows included in the sort. How and where do i write
the macro? Thanks so much for responding!

 

[Guest]

I added an empty row under the 3 header rows and added an atuofiler to each
cell. It works great!

 

[Guest]

I added an empty row under the 3 header rows and added an autofilter to each
cell. It works great!

 

[Otto Moehrbach]

Are you saying that you have it figured out and no longer need help with it?
Confused. Otto

 

[Guest]

Yes I have figured it out. I was just telling how I did it so that if someone
else had the same problem as me they would be able to fix it.

 

[Guest]

Hi Otto,
In my case, I have one column containing employee names, with each employee
name spread across 10 merged cells, and the rows of those merged cells
containing information specific to each employee..so the way I want
autofilter to work is that when I select a particular employee name from the
list, it should show the 10 rows for that employee, and not just the first
row, as is happening as of now..
Please help.
Regards,
Ashish