I'm not sure if this is possible...

Am creating a multi-page worksheet.
Page 1 contains data from registrants to a multi-distance race. 30 mile, 50
mile, 100 mile.
On that page will be a column indicating which distance.

Page 2 will be the 30 mile
page 3 will be the 50 mile
page 4 will be the 100 mile

How can I have the data automatically forward to the corresponding page?
There must be a function/formula that says if this number is 30, put this row
of data on the 30page... if this number is 50, put this row of data on the
50page....

I don't want to do the filter function because there can be late
registrants and it would (I believe...) mean filtering and copying again to
the corresponding distance page.

Questions? Am I on the right track?
LInda

Hi!

Post an email address and I'll send you a sample file that demonstrates how
this CAN be done.

Biff

"Linda" wrote in message
...
I'm not sure if this is possible...

Am creating a multi-page worksheet.
Page 1 contains data from registrants to a multi-distance race. 30 mile,
50
mile, 100 mile.
On that page will be a column indicating which distance.

Page 2 will be the 30 mile
page 3 will be the 50 mile
page 4 will be the 100 mile

How can I have the data automatically forward to the corresponding page?
There must be a function/formula that says if this number is 30, put this
row
of data on the 30page... if this number is 50, put this row of data on the
50page....

I don't want to do the filter function because there can be late
registrants and it would (I believe...) mean filtering and copying again
to
the corresponding distance page.

Questions? Am I on the right track?
LInda

This is possible, but first, have you thought about using Data Filter
AutoFilter?

Say you have your table in the range A1:C7.
The first column contains the distance, the second the competitor's name and
the third some data you need to SUM.

Having selected SutoFilter, now click on the dropdown in column A and select
one of the distances - only those rows showing that data appear.

If you want to do some analysis of the data, but only on those rows, you can
use the SUBTOTAL function.
For example, to see how many rows of competitors are displayed put this
formula in cell A8: =SUBTOTAL(2,A1:A7)
Or to SUM the stats in column C put this formula in cell C8:
=SUBTOTAL(9,C1:C7)

There's more information about this function in the excel Help file (and a
little more he http://www.bygsoftware.com/Excel/functions/subtotal.htm)

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Linda" wrote in message
...
I'm not sure if this is possible...

Am creating a multi-page worksheet.
Page 1 contains data from registrants to a multi-distance race. 30 mile,
50
mile, 100 mile.
On that page will be a column indicating which distance.

Page 2 will be the 30 mile
page 3 will be the 50 mile
page 4 will be the 100 mile

How can I have the data automatically forward to the corresponding page?
There must be a function/formula that says if this number is 30, put this
row
of data on the 30page... if this number is 50, put this row of data on the
50page....

I don't want to do the filter function because there can be late
registrants and it would (I believe...) mean filtering and copying again
to
the corresponding distance page.

Questions? Am I on the right track?
LInda