Preparing Roster for my Teams

G

goodman94

New Member
Joined
Feb 22, 2011
Messages
1
Dear Friends,

I've just a Tast of Excel and not much of an Advance user. I've a Problem I wanna ask you guys. Theres this weekly Roster which is shared to our team by the Roster making team. The Roster follows certain pattern that is there are like for example 5 Teams working in a Unit.

Roster Goes like this.
<TABLE style="WIDTH: 358pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=477><COLGROUP><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" width=29><COL style="WIDTH: 48pt" span=7 width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #a6a6a6 1pt solid; BACKGROUND-COLOR: #984806; WIDTH: 22pt; HEIGHT: 15.75pt; BORDER-TOP: #a6a6a6 1pt solid; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl65 height=21 width=29> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; WIDTH: 48pt; BORDER-TOP: #a6a6a6 1pt solid; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>21-Feb</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; WIDTH: 48pt; BORDER-TOP: #a6a6a6 1pt solid; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>22-Feb</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; WIDTH: 48pt; BORDER-TOP: #a6a6a6 1pt solid; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>23-Feb</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; WIDTH: 48pt; BORDER-TOP: #a6a6a6 1pt solid; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>24-Feb</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; WIDTH: 48pt; BORDER-TOP: #a6a6a6 1pt solid; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>25-Feb</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; WIDTH: 48pt; BORDER-TOP: #a6a6a6 1pt solid; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>26-Feb</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; WIDTH: 48pt; BORDER-TOP: #a6a6a6 1pt solid; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>27-Feb</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #a6a6a6 1pt solid; BACKGROUND-COLOR: #984806; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl67 height=21>TL</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68>Mon</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68>Tue</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68>Wed</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68>Thu</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68>Fri</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68>Sat</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #984806; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68>Sun</TD></TR></TBODY></TABLE>
<TABLE style="WIDTH: 358pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=477><COLGROUP><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" width=29><COL style="WIDTH: 48pt" span=7 width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #a6a6a6 1pt solid; BACKGROUND-COLOR: #fde9d9; WIDTH: 22pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl65 height=21 width=29>A1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66 width=64>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ffcc00; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl67 width=64>OFF</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #a6a6a6 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68 height=21>B1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ffcc00; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl67>OFF</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ffcc00; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl67>OFF</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #a6a6a6 1pt solid; BACKGROUND-COLOR: #fde9d9; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl65 height=21>C1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ffcc00; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl67>OFF</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #a6a6a6 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl68 height=21>D1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ffcc00; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl67>OFF</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ffcc00; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl67>OFF</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl69>M</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #a6a6a6 1pt solid; BACKGROUND-COLOR: #fde9d9; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl65 height=21>E1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ffcc00; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl67>OFF</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD><TD style="BORDER-BOTTOM: #a6a6a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #a6a6a6 1pt solid" class=xl66>M1</TD></TR></TBODY></TABLE>

OK TL Means Team Name.. Ofcourse I changed them. Now the Above roster follows a Pattern where for the Next Week, A1 Team will Follow the B1 Roster and B1 will Follow C1 for their Next Week and C1 For D1 and so Forth. And whole year the Same patterns repeats itself. Now Simple copy pasting is a Bit Difficult and Error ****. Keeping in mind that we deal with atleast 50+ Teams. I've just mentioned 5 here for the sake of example.

My Question is, Is there anyway I can automate this task in Excel. I'd appreciate your kind response...

Regards,
Goodman94
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
388
smozgur
smozgur
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question
VBA for Web Scraping help
Replies
0
Views
819
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top