Importing entry spreadsheet into master workbook

Hi there

I'm running an excel based competition at work for our National Rugby
competition where each week each entrant simply selects the name of the
winning team for each of a set number of games (entrants then score points
based on how well their selected teams perform, which accumlate week by
week.)

OK ... there'll be two main spreadsheets - a master workbook and weekly
entry spreadsheets. Naturally the entry spreadsheets will be sent out to
everyone who'll mark the teams they chose and send back to me to transfer
into the master workbook. Aside from the cut n paste method is their a way
I can import the data from the entry spreadsheet into the master work book?

A sample of the entry spreadsheet is below.

Hawke's Bay

x
Canterbury

Manawatu

x
Auckland

Counties Manukau
x

Otago

Taranaki
x

Wellington

Northland
x

Southland

Tasman

x
North Harbour



I'm currently trying to decide if I should have a different sheet for each
entrant (and work down as we progress through the weeks) or if I'd be better
off using a separate sheet for each round.

How do I import the data and know it's gone to the right place in the master
workbook?

I'd also like to have a smarter way of selecting the team too ... perhaps
pushing a 'win' button, but I suspect that involves some programming ... ?

Cheers
Tony

NB Excel version Office Premium 2002

Sorry ... sample failed ... now as attached.

"Tony" <tesrof@quicksilver.net.nz> wrote in message
news:1152086742.170180@drone2.qsi.net.nz...
> Hi there
>
> I'm running an excel based competition at work for our National Rugby
> competition where each week each entrant simply selects the name of the
> winning team for each of a set number of games (entrants then score points
> based on how well their selected teams perform, which accumlate week by
> week.)
>
> OK ... there'll be two main spreadsheets - a master workbook and weekly
> entry spreadsheets. Naturally the entry spreadsheets will be sent out to
> everyone who'll mark the teams they chose and send back to me to transfer
> into the master workbook. Aside from the cut n paste method is their a
> way
> I can import the data from the entry spreadsheet into the master work
> book?
>
> A sample of the entry spreadsheet is below.
>
> Hawke's Bay
>
> x
> Canterbury
>
> Manawatu
>
> x
> Auckland
>
> Counties Manukau
> x
>
> Otago
>
> Taranaki
> x
>
> Wellington
>
> Northland
> x
>
> Southland
>
> Tasman
>
> x
> North Harbour
>
>
>
> I'm currently trying to decide if I should have a different sheet for each
> entrant (and work down as we progress through the weeks) or if I'd be
> better
> off using a separate sheet for each round.
>
> How do I import the data and know it's gone to the right place in the
> master
> workbook?
>
> I'd also like to have a smarter way of selecting the team too ... perhaps
> pushing a 'win' button, but I suspect that involves some programming ... ?
>
> Cheers
> Tony
>
> NB Excel version Office Premium 2002
>
>