Need to split a LONG list into separate sheets based on repeating, incremental nunbers

Hello all,

This is my first post, so if I've neglected some other more appropriate channel for this question please let me know.

I have a long list of participant numbers, and scores from a particular task, and I need to separate each participant's data into a separate worksheet. Their number repeats throughout the sheet (due to the nature of how I extracted it), and each person has 2 session's worth of data (stored in 2 sets of columns). Any help would be greatly appreciated, as my other option involves lots of cut/copy/pasting...I have attached the workbook in question.


eprime.xls

Hello,

I dont follow what it is exactly your wanting. Can you create one sheet inside of the workbook of what the output should be?

Thanks Mike

Hey,

Here's a version with an 'example' sheet included

eprime_ex.xls

Heres a code and function that will due what you want. The function is to make sure the new sheet name is valid

Please Login or Register  to view this content.

It's giving me a
"compile error:
variable undefined"
and selecting the Sub while highlighting 'ws' in this line of code:
" For Each ws In Worksheets "

I inserted a new module and copied the code into it in the VBA editor. Should I have split the Sub from the Function or is this something else?

Add

Please Login or Register  to view this content.

Im not sure what that problem could be. Maybe your computers memory is lacking because all sheets is held into memory. Also excel 2003 can only have 255 worksheets in workbook.

It very well could be the memory, as I'm not working with that many sheeets, plus these are work computers and are known around the lab for being infamously bad. Thank you so much for your help though, I can figure this out from here!

whoops! I marked it (I think...). thanks for the reminder.