Sheet 1 is my reports with various info. sheet 2 is an alphbetized list of
the same info. Is there a way I can enter info on the reports sheet and it
will automatically update the alphabetized sheet?

thanks for your help
marie