Automatic sort on change in one column

Hello, I have tried various VBA scripts from google searches and can't get them to work properly. Thank you in advance if you can help !

I want to create a page in a workbook which has an address (street name) column (and some others) - that "Street Name" column will have data appended to it from other forms in the workbook. When that column gets a new entry, I would like it to automatically resort the page. The sort will be on Column "B" and I need data in all Columns to the left and to the right of column "B" to stay respective. Column "A" will have a street number, "B" Street name, C-J will have dates respective to the record associated with "A"/"B"

Thanks for all your work !

If column B is changed by a formula, you may need a Worksheet_Calculate event...

Please Login or Register  to view this content.

Thank you very much !!