I have a workbook that contains in its main page a lot of data. The data
contains test #'s, times, and some other data related to those test #'s and
times. (Details not important...) There are multiple times for each test #
as well--The test # column would be like:
Test # Time
1 115
1 250
2 119
2 175
2 225 ...and so on, and there is no pre-determined number of
times for each test--quite variable. There could be 3 times for test 1 and
12 for test 2 and 5 for test 3 and so on...Anyways, what I need to do is copy
all of the data for each test # into sheets dedicated to each test #. I've
managed to achieve this somewhat with if statements, but it doesn't put the
copied data at the top of the new sheet (each sheet is already created too,
by the way). I also need any blanks that are returned to remain blank--no
0's--they corrupt the eventual calculations...

I can use either macros or plain formulas, but I'm very new to macros and
vba and don't understand them very well, so please explain the vba/macro
solutions. Thanks!
-Mark