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.
Bookmarks