Separating content into multiple worksheets

**schmitty** · 10-15-2012, 02:37 PM

So, I have an Excel sheet with 6 columns (A-F), and almost 2,000 rows. I would like to know if there is a more efficient way to separate the content into several worksheets. Based on the name that is found in column C. Right now I'm just selecting all of the rows that belong together, and cut/pasting them into a new worksheet. Any suggestions would be great!

**Tartarus** · 10-15-2012, 03:19 PM

Take a look at this thread:-

Please Login or Register  to view this content.

**Melvinrobb** · 10-15-2012, 03:26 PM

In the individual sheets, put the name you name in column C you want this sheet to contain in cell "I1". the data should autofill into the sheet.
you will then need to copy the list and paste special-values, then sort to get the appropriate cells to the top.
There is a better way than this, but it seems this is a one time project, so this should work fine.