Auto Sorts and Unique ID's

Hello All,

First time post. I don’t have any VB or Macro knowledge really but I am enthusiastic & that's what counts right? I have an Excel dream, just presently not the skills.

I would like to have the attached s/sheet table auto sort whenever a change is made- I currently have the table sorted on - 'Status', then 'Assigned' and finally 'Last Updated'. The purpose of this being whenever a 'Status' is changes to closed the row is auto sorted to the bottom of the table.

Could anybody help with this?

Also I would like WiP Id column to have a unique id auto populate each time a new row is added to the bottom of the table, something like WiP0001 and increment from there, is that possible?

If you have read this, thanks for your time.