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?

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?

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!

"Otto Moehrbach" wrote:

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?

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

"Hodak" wrote:

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!

"Otto Moehrbach" wrote:

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?

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

"Hodak" wrote:

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

"Hodak" wrote:

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!

"Otto Moehrbach" wrote:

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?

Are you saying that you have it figured out and no longer need help with it?
Confused. Otto
"Hodak" wrote in message
...
I added an empty row under the 3 header rows and added an atuofiler to each
cell. It works great!

"Hodak" wrote:

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!

"Otto Moehrbach" wrote:

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?

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.

"Otto Moehrbach" wrote:

Are you saying that you have it figured out and no longer need help with it?
Confused. Otto
"Hodak" wrote in message
...
I added an empty row under the 3 header rows and added an atuofiler to each
cell. It works great!

"Hodak" wrote:

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!

"Otto Moehrbach" wrote:

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?

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

"Otto Moehrbach" wrote:

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?