Please Help Complex Data Manipulation!

[HeyItsTJ4]

I am in desperate need of some assistance, this is due as of yesterday. I have a worksheet that has Name, Address, Dog name, etc. for a Dock Dog competition. I need the data pulled to new worksheets, according to what time slot the Dog and Handler is signed up for, then I would like to sort the new time slot sheet by the score that is manually input. I have the time slot worksheets, in the workbook already so you will know how it looks when manually input. Thanks in advance for any help.

You can download the workbook here to help me out:
online backup

 

[HeyItsTJ4]

Well sort of, actually I need a sheet populated for each time slot. If a column on the first sheet contains a 1 then populate the data to a new sheet for that column. So for instance, if Charlie Buckett is scheduled for 1:00pm, 3:00pm and 4:00 pm. His name would appear on three different sheets along with any other Dogs that are scheduled for that time slot. Say John Doe, and Charlie Brown are also scheduled for 1:00pm, their data would appear along with Charlie Buckett's on the worksheet containing all of the dogs scheduled for 1:00pm. Thanks for your help, I have been having such a time with this, I've tried some formulas floating around. I'm not sure if I put them in the correct place in excel, or if I didn't edit them correctly. I was putting them in the code for the sheet, then I tried in the workbook code, then in a module. So please also let me know where to put the code you come up with.

 

[kunal_shrivastava]

Hi,

Please revert in case my understanding is not as per the requirement :

1. You want a MACRO code that can create 10 new sheets in existing worksheet as per the timeslots mentioned in the main sheet.
The name of the newly added sheets will be same as the time slot for which it is created.
<TABLE style="WIDTH: 436pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=576 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=42><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" span=2 width=50><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=42><TBODY><TR style="HEIGHT: 27pt" height=36><TD class=xl63 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 27pt; BACKGROUND-COLOR: #efefef" width=64 height=36>Fri 12pm</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 62pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=82>Fri 230pm</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 47pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=62>Sat 9am</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=58>Sat 1030am</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 32pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=42>Sat 12pm</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 47pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=62>Sat 2pm</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>Sun 12:00pm</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 38pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=50>Fri 430pm</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 38pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=50>Sat 430pm</TD><TD class=xl64 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 32pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=42>Sun 10am</TD></TR></TBODY></TABLE>

2. In each sheet, we need to populate the names of the dogs for which are allocated to the time slot for which the sheet is created.


3. As per the example you shared we will have below data in "Sat 1pm" time slot sheet.
<TABLE style="WIDTH: 302pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=403 border=0><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 id=td_post_2704559 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #efefef" width=64 height=21>D_Name</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>Breed</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>Sex</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>Age</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 62pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=83>Hometown</TD><TD class=xl65 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>SCORE</TD></TR><TR style="HEIGHT: 27pt" height=36><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 27pt; BACKGROUND-COLOR: #efefef" width=64 height=36>Charlie Buckett </TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>Rat Terrier</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>f</TD><TD class=xl67 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=middle width=64>#####</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 62pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=83>Dawsonville GA</TD><TD class=xl66 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=64>9.1</TD></TR><TR style="HEIGHT: 39.75pt" height=53><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 39.75pt; BACKGROUND-COLOR: #efefef" width=64 height=53>John Doe</TD><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>Golden Retriever</TD><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>M</TD><TD class=xl69 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=middle width=64>#####</TD><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 62pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=83>Cumming, GA</TD><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=64>12</TD></TR><TR style="HEIGHT: 39.75pt" height=53><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 39.75pt; BACKGROUND-COLOR: #efefef" width=64 height=53>Charlie Brown </TD><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64>Labrador Retriever Yellow</TD><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=64> </TD><TD class=xl69 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=middle width=64>#####</TD><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 62pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" width=83>Douglasville, GA</TD><TD class=xl68 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef" align=right width=64>11</TD></TR></TBODY></TABLE>

 

[HeyItsTJ4]

Exactly, so when I enter someones name on the sheet and their dog name and details, then I enter a 1 for what time they are registering for. Then I run the macro and it will automatically populate a new sheet for that timeslot. Thank you so much for your persistence.

 

[HeyItsTJ4]

Exactly, so when I enter someones name on the sheet and their dog name and details, then I enter a 1 for what time they are registering for. Then I run the macro and it will automatically populate a new sheet for that timeslot. Thank you so much for your persistence. So this way I can make a printout for that time slot for the announcer to announce who is competing at this time. Then After they compete I will enter their scores. So essentially you are just pulling the data from the registration worksheet, when you run the macro, but it should go ahead and make the blank rows for score et.c, if you give me the basic code and tell me where I need to put it. I can just edit it and add anything I need to it. I just don't know the basic code to pull from one worksheet to another.