Sorting Data Advice please

[Dermot]

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 Govier]

Hi

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

 

[Dermot]

Thanks Rodger

Hi

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