Agent 0 All American 5677 Posts user info edit post |
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 |