sorting by date

  • Thread starter Thread starter fionabaths
  • Start date Start date
F

fionabaths

Date Account Total Amt GST Expense Type - are my column headings,
22/10 Bunnings 23.10 2.31 maintance - is a
eg of the data.



I've formatted the date column to dd/mmm, the others are either genera
or currency

The GST column has got a the formula =a4/11 in it



:( Sorry for not including this in the first place - is there anythin
else that I need to put in???

Thanks Casey

Fiona :
 
Fiona,
If the data is all entered, you can just use the Sort feature under th
Data menu. DATA>SORT. Before you go there be sure you have selected
cell within the range of your data. For example if your column headin
"Date" is in A1 select A2. Down at the bottom of the Sort dialog selec
"Header Row" and then back at the top under "Sort by" select from th
drop down list "Date". Click OK.

There are automatic sorts that can be done with VBA if you are at al
familar with the Visual Basic Editor. Let me know if this helps
 
Back
Top