Import from One Sheet to various Sheets Automatically

G

Guest

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..
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel, assign cells in multiple worksheets from one sheet 1
formula to move a scored number to a score sheet 1
Excel: Combine contents from identical cells on multiple sheets. 1
Copy Data from One sheet to Different Sheets 1
copying text on sheet 1 to corresponding cells on sheets 2 to 5 5
Command to update data from one sheet to another 1
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
Macro to Combine Data from Multiple Sheets with Cell References 4

Top