Posts1Registration dateTuesday January 25, 2011StatusMemberLast seenJanuary 25, 2011
Jan 25, 2011 at 04:03 PM
Posts4479Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Jan 27, 2011 at 09:02 AM
I have a spreadsheet with Employee names (A2...A150) & one of 5 Divisions that they work for (B2...B150). What I am trying to do is put them in a new sheet that will separate them into columns based on the Division that they work for. For instance, the new sheet (Sheet 2) would list each of the 5 divisions at the top of each column and then list the employees in alphabetical order that work for those divisions underneath.
So Employee1 who works in Division3 and Employee2 who works in Division4 will be listed on the new sheet under their respective divisions. I need Sheet 2 to update according to the list on Sheet 1.