Hi All, I have a worksheet that has several columns, one with dates.
I would like to sort the rows by that date column. When I click the column
and sort it sorts only that column. I would like all rows to stay associated
with there original rows (more like a database would) Any help please.
Thanks, ED

Before you sort, select the entire table. Then try the sort again. Note
that Excel has problems sort non-contiguous columns (i.e., columns that are
not directly next to each other.)

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"pilgrim" wrote:

Hi All, I have a worksheet that has several columns, one with dates.
I would like to sort the rows by that date column. When I click the column
and sort it sorts only that column. I would like all rows to stay associated
with there original rows (more like a database would) Any help please.
Thanks, ED

select all the columns and then sort on the date column and the association
will be retained

"pilgrim" wrote:

Hi All, I have a worksheet that has several columns, one with dates.
I would like to sort the rows by that date column. When I click the column
and sort it sorts only that column. I would like all rows to stay associated
with there original rows (more like a database would) Any help please.
Thanks, ED

Is there a way to lock the columns together so someone else does not missort
the worksheet?

"Mike" wrote:

select all the columns and then sort on the date column and the association
will be retained

"pilgrim" wrote:

Hi All, I have a worksheet that has several columns, one with dates.
I would like to sort the rows by that date column. When I click the column
and sort it sorts only that column. I would like all rows to stay associated
with there original rows (more like a database would) Any help please.
Thanks, ED

Probably easier to remove the sort icons from the toolbar - that way
the user will have to use Data | Sort where there is a bit more
intelligence programmed in.

Hope this helps.

Pete

On Feb 6, 7:25 pm, pilgrim wrote:
Is there a way to lock the columns together so someone else does not missort
the worksheet?



"Mike" wrote:
select all the columns and then sort on the date column and the association
will be retained

"pilgrim" wrote:

Hi All, I have a worksheet that has several columns, one with dates.
I would like to sort the rows by that date column. When I click the column
and sort it sorts only that column. I would like all rows to stay associated
with there original rows (more like a database would) Any help please.
Thanks, ED- Hide quoted text -

- Show quoted text -