Hi,
I have data on a worksheet with multiple columns of information from an experiment going down in rows. One of the the columns identifies the trial type (1, 2, 3 or 4) The trials are multiple cells long (roughly 200 cells), and occur multiple times with breaks between trials that are ID'd as 0). The trial ID column looks a little like this:
0
0
0
1
1
1
.
.
.
1
1
1
0
0
0
0
0
3
3
3
3
.
.
3
3
3
0
0
0
0
0
2
2
2
.
.
.
2
2
2
0
0
0
etc...

I would like to use a macro that takes all the information for each trial, and puts this on a seperate worksheet that is labled in accending order, e.g. 1,2,3,4,5,6, etc, and has the trial type on it (1:4). So the worksheet for the second tiral might be 2_3.
I've seen scripts that allow this to be done if the data only occurs once, ie. a new worksheet for a different name, however I need to have a worksheet for each occurance of a section of data.
Thank you in advance for any help!
Ben