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
Bookmarks