Hi Danny,

Am Tue, 9 Apr 2013 14:40:59 +0000 schrieb DannyQuinn:

I have started a developer tab and I'm able to use VBA.

Could you please advise from here?

please look he
https://skydrive.live.com/#cid=9378A...121822A3%21191
for the workbook "Danny"
Right-click and download it, because VBA is not enabled in SkyDrive.
If you write an "a" in column E your data will be sorted by color (a)
and date in D
The code is in Worksheet_Change-event


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2