ExcelBanter - View Single Post

Ryan H

Sure e-mail it to:

--
Cheers,
Ryan

"joe the soccer dude" wrote:

my spread sheet with the data is as follows
A B C D ETC
------------------------------------------------------------------
NO NAME SURNAME TELE
1 JOE XXXX 1111-1111
2 RYAN YYYYY 2222-333

IT GOES ON LIKE THIS TILL 300

FROM THIS INFORMATION I WANT TO TRANSFER IT INTO ANOTHER SHEET THAT LOOKS
LIKE THIS

NO NAME SURNAME
1
2
3
4
5
6

I HAVE 50 OF THESE GROUPS LIKE THIS SO FROM 1 TO 300 NEEDS TO POPULATE
THESE GROUPS MAYBE I COULD EMAIL YOU MY WORKBOOK AND YOU COULD HAVE A LOOK AT
IT HOW I HAVE IT CURRENTTLY
"Ryan H" wrote:

Sure that is possible. But we need to know more about how your Sheets are
arranged. For example, is your sheet1 like this

A B C
1 Group 1 Group 2 ...
2 Ryan Chris
3 Kevin Todd
4 Sam Brian
5 George Jim
6 Juan Jorge

or like this
A B C D
1 Group 1 Ryan Kevin Sam...
2 Group 2 Chris Todd Brian ....

Just describe the name and surname column locations.
--
Cheers,
Ryan

"joe the soccer dude" wrote:

Hello
My question is quite simple but i have no idea on how to go about it.I hope
that you guys will be able to assist.
We a community based soccer club and we run soccer festivals for kids on a
regular basis. My main problem is that we need to place these kids into
random groups. I have approximately 300 kids data on a spreadsheet with all
their particulars. What we normally do is manually put the kids names on a
seperate sheet into groups. I have 50 groups with 6 kids in each group. Is it
possible to be able to at the click of a button export just the name and
surname from sheet 1 into the grouops that i have created in sheet 2.