Import from One Sheet to various Sheets Automatically

[RidingClubSec]

Background: We have a Workbook with 58 Sheets for our Riding Club Shows (one
for each class) When a Competitor enters the horse show they select which
classes they wish to compete in. Currently we type in their details in three
columns on the sheet for the first class they enter, copy the three cells and
paste them into the next available line on the rest of the sheets/classes
they have entered. When the Competition is ready to start for each class we
print the sheet for the Judge to use.

What we want Excel to do: .. it would be easier if we could input the three
cells of data onto a single sheet and then in the next Cell enter the
sheets/classes they have entered (eg: 5, 9, 27, 51, 58) and then have Excell
automatically input the three detail cells into the sheets on their next
available line.

It is probably really easy answer but I have no knowledge of working with
Excel, and we are a Non-Profit Sports organisation mainly for young riders to
compete with us..

 

[Dave Peterson]

I don't think I'd make it automatic. Too much could go wrong and correcting a
mistyped entry could be difficult.

I think I'd either put all the data on one worksheet, then autofilter on each
class and print those.

But if you really wanted to create new worksheets...

Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
may be sufficient right out of the box.

Debra's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

And Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm