I have a single spreadsheet open. It contains data for people from almost all 50 states that I need to manipulate.

Ultimately, I would like to be able to highlight the "state" column, and have it automatically distribute the individual entries into separate worksheets it automatically creates based on which state value is in the state column.

Does anyone know a way to do this? I'm in Excel 2010 for PC. But I also have access to Excel for Mac if that's something that's helpful.

Thoughts? Questions as to what the fuck I am trying to say?

4/17/2013 10:47:24 AM

http://www.ozgrid.com/forum/showthread.php?t=82101

4/17/2013 11:04:56 AM