Sorting Data Advice please

Assuming I have 20 Columns or more with headers.
Column C has a date field, and I have define a name for it "Date" relevant
to each row.
I want to sort all the rows in date order.

Question 1
Dragging the mouse over a large number of colums an rows could be tedious.
What is the quickest way to sort the rows in date order automatically
without having to select the cell range everytime a new row of data are
entered?

Roger
Sat Mar 15 03:41:38 CDT 2008

Hi

Just select all 20 columns, don't worry about the rows as blank rows will
always be at the end of the list.

--
Regards
Roger Govier

"Dermot" <Dermot@discussions.microsoft.com> wrote in message
news:B3394AC5-9B0F-46A8-9CFE-2794438641DB@microsoft.com...
> Assuming I have 20 Columns or more with headers.
> Column C has a date field, and I have define a name for it "Date" relevant
> to each row.
> I want to sort all the rows in date order.
>
> Question 1
> Dragging the mouse over a large number of colums an rows could be tedious.
> What is the quickest way to sort the rows in date order automatically
> without having to select the cell range everytime a new row of data are
> entered?
>
>
>
>
>

Dermot
Sun Mar 16 08:35:01 CDT 2008

Thanks Rodger

"Roger Govier" wrote:

> Hi
>
> Just select all 20 columns, don't worry about the rows as blank rows will
> always be at the end of the list.
>
> --
> Regards
> Roger Govier
>
> "Dermot" <Dermot@discussions.microsoft.com> wrote in message
> news:B3394AC5-9B0F-46A8-9CFE-2794438641DB@microsoft.com...
> > Assuming I have 20 Columns or more with headers.
> > Column C has a date field, and I have define a name for it "Date" relevant
> > to each row.
> > I want to sort all the rows in date order.
> >
> > Question 1
> > Dragging the mouse over a large number of colums an rows could be tedious.
> > What is the quickest way to sort the rows in date order automatically
> > without having to select the cell range everytime a new row of data are
> > entered?
> >
> >
> >
> >
> >