I've tried the VB for my auto sort but I guess I'm making mistakes somewhere. Any help would be appreciated.

I would like to sort col a, b, c in decending order using col b as my data entry col. I only want to sort the 3 columns to row 6.

Thanks