Macro Question

DKRbella0814

Board Regular
Joined
Aug 10, 2008
Messages
155
I have a workbook that has been constructed as follows

sheet1 = data (production data specific to machining cells (there are 6 cells total))

CL = constraint lathe
L09 = Lathe constraint
M01 = Mill constraint
M03 = Mill constraint
Plastic constraint
VCM = vertical constraint mill

On any given day, a maximum of three of the above cells will be active on the floor, and production data will be gathered for each of the machines that were running within that cell.

sheet2 = CL Map (should pull active jobs (from data sheet) and paste them into appropriate cells on the map of the machining cell)

sheet3 = CL (production - expected vs actual calculations); should pull actual # pcs run per time period (from data sheet) and past them into appropriate cells on the form to generate expected vs actual calculations.


*The Map and Calculation sheets are set up within the SAME workbook for each of the 6 machining cells referenced above.

So,

sheet4 = L09 map
sheet5 = L09 Calculations
Sheet6 = M01 Map
sheet7 = M01 Calculations
sheet8 = M03 map
sheet9 = M03 Calculations
sheet10=Plastic map
sheet 11=Plastic calculations
sheet 12=VCM map
sheet 13 = VCM calculations


My question is whether there is a way to write a macro that would look up the active row in the data sheet and identify which machining cell it is for so that it would copy and paste the values from the data sheet into the appropriate Map and Calculation worksheets contained within the same workbook. OR...do I have to write individual macros and have the user of the workbook select the correct macro to run from the Macros menu based on which cell they are entering the data for?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Hi DKRbella0814,

I believe the simple answer to your question is that yes it probably would be possible to write a macro to do what you want, but the problem is understanding what you want.

Would it be possible to post an example of your Sheet1, and of say Sheets 4 & 5 so we've got an idea of what we are dealing with.

ColinKJ
 
Upvote 0
I basically have set up the Data sheet as repeating columns of data for each machine that is part of a specific cell of machines.

Based on which machining cells were scheduled to run for the day, the scheduler would enter the following information in the first few columns of data:

B3 = Today's date
C3 = Active Cell (M01, M03, Plastic, VCM, L09, CL); when one of these cells is selected from a drop down list, then the appropriate machines within those cells will be populated in cells J3, AG3, BD3, CA3, CX3, DU3, & ER3
D3 = Shift (1, 2, 3 - Overlap, 3 - No Overlap); drop down list
E3= Scheduler (drop down list- roster)
F3= Tech Support (drop down list - roster)
G3 = Set Up #1 (drop down list - team roster)
H3 = Set Up #2 (drop down list - team roster)
I3 = 6S (drop down list - team roster)

*For cells J3, AG3, BD3, CA3, CX3, DU3, & ER3, the catch is that the machining cells can have up to 7 machines per cell, but do not necessarily have 7 machines.- If all cells have been populated, the remaining cells will stay blank.

The formulas for each of J3-ER3 are as follows:(all formulas have been copied down to row 5000 for the appropriate column

J3 = =IF(C3="VCM","M24",IF(C3="CL","L04",IF(C3="Plastic","M05",IF(C3="M01","M01",IF(C3="M03","M08",IF(C3="L09","L09",""))))))

AG3 =
=IF(C3="VCM","M15",IF(C3="CL","L05",IF(C3="Plastic","M10",IF(C3="M01","M28",IF(C3="M03","M03",IF(C3="L09","L10",""))))))

BD3=
=IF(C3="VCM","M34",IF(C3="CL","L12",IF(C3="Plastic","M16",IF(C3="M01","M04",IF(C3="M03","M09",IF(C3="L09","M12",""))))))

CA3=
=IF(C3="VCM","M14",IF(C3="CL","L06",IF(C3="Plastic","M17",IF(C3="M01","",IF(C3="M03","M20",IF(C3="L09","L03",""))))))

CX3=
=IF(C3="VCM","M06",IF(C3="CL","L07",IF(C3="Plastic","M19",IF(C3="M01","",IF(C3="M03","",IF(C3="L09","L01",""))))))

DU3 =
=IF(C3="VCM","M31",IF(C3="CL","L13",IF(C3="Plastic","M35",IF(C3="M01","",IF(C3="M03","",IF(C3="L09","",""))))))

ER3 =
=IF(C3="VCM","",IF(C3="CL","M13",IF(C3="Plastic","M18",IF(C3="M01","",IF(C3="M03","",IF(C3="L09","",""))))))


Between each machine is a set of standard data which repeats for all machines: So, for example, between cells J3 and AG3, AG3 and BD3, etc. are the following data:

Ex:

K3 = Backup (from drop down list- roster of shop floor)
L3 = Loader (from drop down list- roster of shop floor)
M3 = Inspector (from drop down list- roster of shop floor)
N3= Job#1 (job currently running on shop floor on that specific machine)
O3= work order qty for Job#1
P3 = Lot#
Q3 = Op# for Job #1
R3= MPP (minutes per piece for job #1)
S3 = Job#2 (scheduled next to run on that machine)
T3 = work order qty for job #2
U3 = Lot 3
V3= Op # for Job #2
W3 = MPP (minutes per piece for job #2)
X3= Time (first increment of time that # of good pieces produced are counted and recorded (compared to projected # that should be completed))
Y3 = # Parts
Z3 = Time (second increment of time that # of good pieces produced are counted and recorded (compared to projected # that should be completed))
AA3 = # Parts
AB3 = Time (third increment of time that # of good pieces produced are counted and recorded (compared to projected # that should be completed))
AC3 = # Parts
AD3 = Time (fourth increment of time that # of good pieces produced are counted and recorded (compared to projected # that should be completed))
AE3 = # Parts
AF3 = Total # Parts ran on the designated shift (1st, 2nd, 3rd) ; sum of x3, z3, ab3, and ad3

*For cells that reference the increments of time that parts are counted (i.e. x3, z3, ab3, and ad3), there is a formula contained in these cells which reference cell D3 = shift (drop down list - see above)

The formulas are written as follows and repeat for all cells labeled "Time", as they should correspond to the correct time increment for the appropriate shift.

X3 =
=IF(J3="","",IF(D3=1,"7:00-9:50 AM",IF(D3=2,"3:15-5:30 PM",IF(D3="3 - No Overlap","10:45-1:30 AM",IF(D3="3 - Overlap","11:40-1:30 AM","")))))

Z3 =
=IF(J3="","",IF(D3=1,"9:50-11:55 AM",IF(D3=2,"5:30-7:55 PM",IF(D3="3 - No Overlap","1:30-2:55 AM",IF(D3="3 - Overlap","1:30-2:55 AM","")))))

AB3 =
=IF(J3="","",IF(D3=1,"11:55-1:50 PM",IF(D3=2,"7:55-9:50 PM",IF(D3="3 - No Overlap","2:55-5:10 AM",IF(D3="3 - Overlap","2:55-5:10 AM","")))))

AD3 =
=IF(J3="","",IF(D3=1,"1:50-3:20 PM",IF(D3=2,"9:50-11:35 PM",IF(D3="3 - No Overlap","5:10-7:05 AM",IF(D3="3 - Overlap","5:10-7:05 AM","")))))


So, now that you have a sense of how the Data worksheet has been set up, you see that each row of data is variable based on a number of elements including: Shift run (1,2,3 - no overlap, 3- overlap) AND Which machining cell is in operation (VCM, Plastic, CL, L09, M01, M03).

I would like to write a macro that has IF- THEN Logic such that it would read the data on the active row and recognize which machining cell was run (VCM, Plastic, CL, L09, M01, M03) and copy and paste data from the Data sheet into the other appropriate worksheets contained within the workbook.

As mentioned in an earlier post, each machining cell has 2 corresponding sheets -

1) a MAP, which replicates the physical layout of the machines within the cell (job#1, Job#2, and relevant staff data would need to be copied from Data worksheet and pasted to this worksheet); cells are in no organized format.

2) A standardized calculation sheet which takes the # good parts run (recorded on Data sheet - for each increment of time and compares it to the projected # parts that should have been run within that period of time based on the MPP minutes per piece it takes to run a cycle of that particular job).


I know that I can write individual macros for each machining cell and have the end-user select the appropriate program to run from the Macros menu, but for ease of use, I would rather have it contained within a single macro or program.

So, if the active row is = VCM, copy appropriate data from Data sheet into VCM Map sheet and VCM calculations sheet, etc....

The other worksheets contained within the workbook are as follows:

sheet2 = CL Map
sheet3 = CL (calculations)
L09 Map
L09
M01 Map
M01
M03 Map
M03
Plastic Map
Plastic
VCM Map
sheet 13 = VCM


Would someone be willing to help me figure out how to write this code? It will really make my life so much easier!! If there are any other questions, please let me know.

Also, if there is a way to provide you with a look at my spreadsheet, let me know. Thanks!
 
Upvote 0
Hi DKRbella0814,

Can you try a copy and paste like:

Sheet1

<TABLE style="WIDTH: 717pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=956 x:str><COLGROUP><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 48pt" span=14 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 45pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 height=17 width=60>Header1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header2</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header3</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header4</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header6</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header7</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header8</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header10</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header11</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header12</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header13</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header14</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl22 width=64>Header15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>Data1_1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_2</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_3</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_4</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_6</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_7</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_8</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_10</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_11</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_12</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_13</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_14</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data1_15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>Data2_1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_2</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_3</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_4</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_6</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_7</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_8</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_10</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_11</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_12</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_13</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_14</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data2_15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>Data3_1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_2</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_3</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_4</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_6</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_7</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_8</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_10</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_11</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_12</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_13</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_14</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">Data3_15</TD></TR></TBODY></TABLE>

ColinKJ
 
Upvote 0
Anytime I have tried to copy and paste, the message does not hold the formatting of my original file ; if you take a look at my last post, I think it explains the setup of my workbook fairly well.

<table width="12037" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 53pt;" width="71"> <col style="width: 67pt;" width="89" span="6"> <col style="width: 57pt;" width="76"> <col style="width: 57pt;" width="76" span="3"> <col style="width: 52pt;" width="69"> <col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64" span="5"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 59pt;" width="79"> <col style="width: 57pt;" width="76"> <col style="width: 57pt;" width="76" span="3"> <col style="width: 52pt;" width="69"> <col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64" span="5"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 59pt;" width="79"> <col style="width: 57pt;" width="76"> <col style="width: 57pt;" width="76" span="3"> <col style="width: 52pt;" width="69"> <col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64" span="5"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 59pt;" width="79"> <col style="width: 57pt;" width="76"> <col style="width: 57pt;" width="76" span="3"> <col style="width: 52pt;" width="69"> <col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64" span="5"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 59pt;" width="79"> <col style="width: 57pt;" width="76"> <col style="width: 57pt;" width="76" span="3"> <col style="width: 52pt;" width="69"> <col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64" span="5"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 59pt;" width="79"> <col style="width: 57pt;" width="76"> <col style="width: 57pt;" width="76" span="3"> <col style="width: 52pt;" width="69"> <col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64" span="5"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 59pt;" width="79"> <col style="width: 57pt;" width="76"> <col style="width: 57pt;" width="76" span="3"> <col style="width: 52pt;" width="69"> <col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64" span="5"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 64pt;" width="85"> <col style="width: 48pt;" width="64"> <col style="width: 59pt;" width="79"> <tbody><tr style="height: 12.75pt;" height="17"> <td rowspan="2" class="xl92" style="border-bottom: 0.5pt solid black; height: 24.75pt; width: 48pt;" width="64" height="33">Date</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 53pt;" width="71">Active Cell</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 67pt;" width="89">Shift</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 67pt;" width="89">Scheduler</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 67pt;" width="89">Tech Support</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 67pt;" width="89">S/U #1</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 67pt;" width="89">S/U #2</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 67pt;" width="89">6S</td> <td rowspan="2" class="xl104" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Machine(1)</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Loader</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Backup</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Inspector</td> <td colspan="10" class="xl94" style="border-left: medium none; width: 484pt;" width="645">Active Jobs</td> <td colspan="9" class="xl106" style="border-right: 0.5pt solid black; border-left: medium none; width: 507pt;" width="675">Daily Production Data</td> <td rowspan="2" class="xl104" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Machine(2)</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Loader</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Backup</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Inspector</td> <td colspan="10" class="xl105" style="border-left: medium none; width: 484pt;" width="645">Active Jobs</td> <td colspan="9" class="xl106" style="border-right: 0.5pt solid black; border-left: medium none; width: 507pt;" width="675">Daily Production Data</td> <td rowspan="2" class="xl104" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Machine(3)</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Loader</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Backup</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Inspector</td> <td colspan="10" class="xl105" style="border-left: medium none; width: 484pt;" width="645">Active Jobs</td> <td colspan="9" class="xl106" style="border-right: 0.5pt solid black; border-left: medium none; width: 507pt;" width="675">Daily Production Data</td> <td rowspan="2" class="xl104" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Machine(4)</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Loader</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Backup</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Inspector</td> <td colspan="10" class="xl105" style="border-left: medium none; width: 484pt;" width="645">Active Jobs</td> <td colspan="9" class="xl106" style="border-right: 0.5pt solid black; border-left: medium none; width: 507pt;" width="675">Daily Production Data</td> <td rowspan="2" class="xl104" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Machine(5)</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Loader</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Backup</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Inspector</td> <td colspan="10" class="xl105" style="border-left: medium none; width: 484pt;" width="645">Active Jobs</td> <td colspan="9" class="xl106" style="border-right: 0.5pt solid black; border-left: medium none; width: 507pt;" width="675">Daily Production Data</td> <td rowspan="2" class="xl104" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Machine(6)</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Loader</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Backup</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Inspector</td> <td colspan="10" class="xl105" style="border-left: medium none; width: 484pt;" width="645">Active Jobs</td> <td colspan="9" class="xl106" style="border-right: 0.5pt solid black; border-left: medium none; width: 507pt;" width="675">Daily Production Data</td> <td rowspan="2" class="xl104" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Machine(7)</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Loader</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Backup</td> <td rowspan="2" class="xl93" style="border-bottom: 0.5pt solid black; width: 57pt;" width="76">Inspector</td> <td colspan="10" class="xl105" style="border-left: medium none; width: 484pt;" width="645">Active Jobs</td> <td colspan="9" class="xl106" style="border-right: 0.5pt solid black; border-left: medium none; width: 507pt;" width="675">Daily Production Data</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl97" style="height: 12pt; border-top: medium none; border-left: medium none;" height="16">Job#1</td> <td class="xl97" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl97" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl97" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl97" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl98" style="border-top: medium none; border-left: medium none;">Job#2</td> <td class="xl98" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl98" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl98" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl98" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Total # Parts</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Job#1</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Job#2</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Total # Parts</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Job#1</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Job#2</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Total # Parts</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Job#1</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Job#2</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Total # Parts</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Job#1</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Job#2</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Total # Parts</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Job#1</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Job#2</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Total # Parts</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Job#1</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl110" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Job#2</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">W.O. Qty</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Lot</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">Op#</td> <td class="xl111" style="border-top: medium none; border-left: medium none;">MPP</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Time</td> <td class="xl112" style="border-left: medium none;"># Parts</td> <td class="xl112" style="border-left: medium none;">Total # Parts</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl99" style="height: 12pt; border-top: medium none;" align="right" height="16">03/02/11</td> <td class="xl100" style="border-top: medium none; border-left: medium none;">M01</td> <td class="xl100" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl113" style="border-top: medium none; border-left: medium none;">M01</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;">M28</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;">M04</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl113" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl113" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl113" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl99" style="height: 12pt; border-top: medium none;" height="16"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;">CL</td> <td class="xl100" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl113" style="border-top: medium none; border-left: medium none;">L04</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl101" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl102" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;">L05</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;">L12</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;">L06</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;">L07</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;">L13</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl113" style="border-top: medium none; border-left: medium none;">M13</td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl100" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl114" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl115" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">7:00-9:50 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">9:50-11:55 AM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">11:55-1:50 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;">1:50-3:20 PM</td> <td class="xl103" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl116" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> </tbody></table>
 
Upvote 0
Hi DKRbella0814,

Sorry it's taken a while to get back to you.

Again I'm sorry, but I'm going to have to drop out of this, A) because I'm struggling to understand the concept of what your doing, and B) becuase, I've just been pulled into an urgent project for work, and work always has to come first.

Sorry again.

ColinKJ
 
Upvote 0

Forum statistics

Threads
1,224,583
Messages
6,179,672
Members
452,937
Latest member
Bhg1984

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