Excel newbie and idiot: need to make a list of documents.

Hi,

I need to make a list of communications for official purposes. Fields across are: 1.date, 2.file type (email, instant message, report) & 3.sent or 3.received (I could have had one column for sent/received but thought it looked better having separate ones).

I made a worksheet with those fields and drop down menu for file type and sent/received.

However, having entered some data as I found it from emails, or files, I then sorted by date to get newest first; it then added 'sent or received' to fields I had already done. So some dates now have both sent & received by them!

I want to sort by date so I don't have to manually order the info' before I input, but in doing this, I don't want the sent or received changed when I sort by date.

Help

Many thanks,

zaza

A complete 1st time excel user!

where are these documents?