VBA To Sort 2 Columns Automatically

Good afternoon,

Please forgive my ignorance as I have limited VBA exposure.
I found a sample VBA online and have been able to modify it to meet part of my requirements but I cannot seem to get it to update both columns.
I want the macro to sort column B then column A ascending every time there is an update in column D.
Please note that my columns have headers and the true data starts in cells A2:D2.

The following is what I have so far and I would appreciate assistance in having this code automatically sort column B first.

Please Login or Register  to view this content.

See if this works,

Please Login or Register  to view this content.

Notice that it will sort in ascending order by default, and .item(1) = A1 and .item(2) = B1 provided that the data structure works with using currentregion within VBA.

Cheers,
berlan

Wow,

Thank you so much!!!!!!