Excel Formula to populate fields

Closed
graphictees Posts 1 Registration date Tuesday January 25, 2011 Status Member Last seen January 25, 2011 - Jan 25, 2011 at 04:03 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 27, 2011 at 09:02 AM
Hello,

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.

Can this be done?

Thank you in advance for your response.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 27, 2011 at 09:02 AM
It can be done most cleanly by macro. Formula can be tricky and would depend on a lot of other factors. So I suggest look into macro for this
1