Date order

[M@gic]

I would like to use Excel for my accounts
I only need four columns headed....date....description......fee and expenses
I would like a heading for each month and then be able to dive into a pile
of receipts/invoices for that month and enter the description of what its
for then the amount
At the end of inputting that months data I would like to then sort them out
into date order

How can I do this??

Thanks!

Martin

 

[VoG via OfficeKB.com]

Highlight (select) all of the data then Data | Sort and follow the wizard to
sort by your Date entries.

 

[Debra Dalgleish]

After you set up your list, you can use the built in data form to enter
the monthly data.

To use it, select a cell in your list, and choose Data>Form.

You could also try John Walkenbach's Enhanced Data Form. It's a free
add-in that allows combo boxes, and unlimited fields.

http://j-walk.com/ss/dataform/index.htm

There are sorting instructions in Excel's Help, and here:

http://www.contextures.com/xlSort01.html