Hi,
I need to auto sort a data table allphabetically using a formula. I am working with two worksheets, sheet 1 is the source sheet having a data range A1:M13 and sheet 2 is the resulting sheet having the same range. I want the table on sheet 2 auto sorted based on column G when sheet 1 is modified. The sample workbook is attached.
Any help would be appreciated.
Regards.
Bookmarks