I have a worksheet (1) with 2 columns labeled
SYMBOL (col a) - MMID (col B) - sorted by symbol alpha

what I need to accompish is
1. when I update sheet 1 - for it to automatically sort in alph by symbol
(col a)
2. then on worksheet (2) i need create a list sorted alpha by MMID (col b
sheet 1) then sorted alpha by symbol (col a sheet 1). Which will be auto
updated when I update sheet 1.

Is this possible?