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

Using the menu choose DataAutofilter

Then filter for a test, copy the displayed rows to a new sheet, go back &
filter for the next test, and so on


"MAWII" wrote:

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

I should have been more clear--I need each test # worksheet to search the
test #'s and copy those rows of data on their own. The only user interaction
with this workbook should be entering data into the main page--the workbook
performs the rest of the work on its own (maybe with the push of a
button...). I don't want the user to have to copy and paste the data on
their own. Thanks!

"Duke Carey" wrote:

Using the menu choose DataAutofilter

Then filter for a test, copy the displayed rows to a new sheet, go back &
filter for the next test, and so on


"MAWII" wrote:

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

Follow dukes idea, but use an advanced filter.Use a macro to automate it.
Create a macro button on the worksheet to simplyfy things for the user.

"MAWII" wrote in message
...
I should have been more clear--I need each test # worksheet to search the
test #'s and copy those rows of data on their own. The only user
interaction
with this workbook should be entering data into the main page--the
workbook
performs the rest of the work on its own (maybe with the push of a
button...). I don't want the user to have to copy and paste the data on
their own. Thanks!

"Duke Carey" wrote:

Using the menu choose DataAutofilter

Then filter for a test, copy the displayed rows to a new sheet, go back &
filter for the next test, and so on


"MAWII" wrote:

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

If you're interested in downloading a file from a Web site into your
Personal.xls folder, I can suggest a solution; but I don't want to waste
your time nor mine. Post back if you're interested.

Alan Beban

MAWII wrote:
I should have been more clear--I need each test # worksheet to search the
test #'s and copy those rows of data on their own. The only user interaction
with this workbook should be entering data into the main page--the workbook
performs the rest of the work on its own (maybe with the push of a
button...). I don't want the user to have to copy and paste the data on
their own. Thanks!

"Duke Carey" wrote:


Using the menu choose DataAutofilter

Then filter for a test, copy the displayed rows to a new sheet, go back &
filter for the next test, and so on


"MAWII" wrote:


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