Transfere names

G

George A. Yorks

I have designed a score card for a golf course.I have a
group of 40 players whose names I have listed in an exel
file. What is the best way for me to transfere these
names the the score cards, 4 names per card.

George
 
G

Gord Dibben

George

That would depend upon the layout of your scorecard, which I assume is on an
Excel worksheet and which groups of four you want on a card.

Random? By handicap? Do you need to do this many times, which would lead to
a programming method perhaps?

More detail please.

Gord Dibben Excel MVP
 
G

George A. Yorks

-----Original Message-----
George

That would depend upon the layout of your scorecard, which I assume is on an
Excel worksheet and which groups of four you want on a card.

Random? By handicap? Do you need to do this many times, which would lead to
a programming method perhaps?

More detail please.

Gord Dibben Excel MVP



.Gord Gibben
Click to expand...

You are correct that the card is on an excel worksheet,
the names would be transfered randomly, four to a card and
in this situation would need five sets as there are two
cards per sheet.

Thanks for any help

George
 
G

Gord Dibben

George

A combination of cell links and the RAND Function with a Sort would probably
do the trick.

Names are in Sheet1 A1:A40

In B1 enter =RAND()

Copy down to B40

Sort A and B on Column B

Have links in your scorecards Sheet back to the names in Column A.

This gives you the option of re-arranging names each time you Sort.

Send me the workbook if you wish.

Replace the obvious in the email address to mail me the workbook.

DO NOT send to the News Group.

Gord
 
G

George A. Yorks

-----Original Message-----
George

A combination of cell links and the RAND Function with a Sort would probably
do the trick.

Names are in Sheet1 A1:A40

In B1 enter =RAND()

Copy down to B40

Sort A and B on Column B

Have links in your scorecards Sheet back to the names in Column A.

This gives you the option of re-arranging names each time you Sort.

Send me the workbook if you wish.

Replace the obvious in the email address to mail me the workbook.

DO NOT send to the News Group.

Gord



.
I attempted to send the workbook on to you but was not
Click to expand...
successful with you e-mail address. Any further help
appreciated.

George
 
Top