Okay, newbie here.
I have a worksheet with 9 columns of data and 26 rows. Worksheet one is done alphabetically. I want worksheets 2, 3, and 4 to grab the data from worksheet 1 and auto sort, or sort on the click of a button each month after new data is entered. The field of data would be I8:M33.
Sheet 2 would be sorted by column b, sheet 3 by column F, and sheet 4 by column G.
Looking at the same data, just sorted by different criteria. Others will enter data and do not want them to have to copy multiple sheets and manually sort based on criteria. Thanks in advanc e for any help.
Bookmarks