Hope someone out there can help with this! I am using Excel XP.

I have a workbook that is used to log certain requests. Each request has a
priority. If I change the priority I want to be able to automatically log
the changes, user name and date to another worksheet and just retain the
amended data in the original worksheet.

Can anyone out there advise me of a way to do this without having to do it
manually?