Re-Sort Table After Change Has Occurred

[martinpgibson]

Hi there,

I have a table (attached) with some names in column A and a status in column B. I want to sort the table immediately after a change has occurred in table. So if I change the status from the drop down list in column B to let's say "COMPLETE" it will filter that column alphabetically straight after the change. Is this possible?

Thanks so much in advance.

[protonLeah]

This worksheet change code will execute whenever a change is made in column B.

Please Login or Register  to view this content.

---

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Right-click the tab of the desired sheet
4. Choose View Code
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

[martinpgibson]

Thanks protonLeah!