Ideas Please For Holiday Chart

[Dazzawm]

Below is a small sample of a holiday chart. I have 6 sheets that are all the same layout but because of various depots and staff numbers they may stretch down further on some sheets, What I need is a code that will perhaps give a pop up box saying 'Somebody Is Already Booked Of That Day At Depot 1'

e.g on the sample provided if I made an entry in H14 it would look at all the other sheets and see if anything else is entered in column H and the pop up will occur.

I am not sure if this is possible so I would welcome any other ideas as there are so many staff to keep an eye on and I don't want to many off at the same time across the region!

Example

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 164px"><COL style="WIDTH: 92px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"><COL style="WIDTH: 58px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Name</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">January</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">February</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold">March</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">10</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">17</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">24</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">31</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">7</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">14</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">21</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">28</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">7</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">14</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">21</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">28</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">4</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Monday</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Mr Example</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Tuesday</TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">1737</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Wednesday</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Manager</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Thursday</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Friday</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Saturday</TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Name</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">January</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">February</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold">March</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">10</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">17</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">24</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">31</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">7</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">14</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">21</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">28</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">7</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">14</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">21</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">28</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">4</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Monday</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD style="TEXT-ALIGN: center">D</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Mr Example 2</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Tuesday</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">1228</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Wednesday</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Assistant Manager</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Thursday</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Friday</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Saturday</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD></TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Name</TD><TD style="FONT-WEIGHT: bold"></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">January</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">February</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold">March</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">10</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">17</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">24</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">31</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">7</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">14</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">21</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">28</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">7</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">14</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">21</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">28</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">4</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Monday</TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Mr Example 3</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Tuesday</TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">1847</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Wednesday</TD><TD></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Transport Supervisor</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Thursday</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Friday</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center">HP</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Saturday</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD><TD></TD><TD style="TEXT-ALIGN: center">RD</TD></TR></TBODY></TABLE>

 

[Akashwani]

Hi Daz,

I don't have a solution for you, sorry.
How about rearranging your data and putting the holiday chart on one sheet and setting the number of holidays permitted to X number of rows?....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
2	*	*	*	January	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
3	*	*	*	03/01/2011						10/01/2011						17/01/2011						24/01/2011						31/01/2011
4	Name	Depot	No of Days	M	T	W	T	F	S	M	T	W	T	F	S	M	T	W	T	F	S	M	T	W	T	F	S	M	T	W	T	F	S
5	Bart Simpson	Depot1	4	*	*	X	X	X	X	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
6	Ned Flanders	Depot2	5	*	*	*	*	*	*	X	X	X	X	X	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
7	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
8	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
9	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
10	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
Holiday Chart

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
12	*	*	*	February	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
13	*	*	*	07/02/2011						14/02/2011						21/02/2011						28/02/2011						*	*	*	*	*	*
14	Name	Depot	No of Days	M	T	W	T	F	S	M	T	W	T	F	S	M	T	W	T	F	S	M	T	W	T	F	S	*	*	*	*	*	*
15	Bart Simpson	Depot1	2	*	*	*	*	*	*	*	*	*	*	*	*	X	X	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
16	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
17	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
18	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
19	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
20	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
Holiday Chart

Excel Workbook
	A	B	C	D	E
1	Name	Depot	Holiday Allowance	Days taken	Days Left
2	Bart Simpson	Depot1	25	6	19
3	Lisa Simpson	Depot2	25	0	25
4	Grandpa Simpson	Depot3	30	0	30
5	Marge Simpson	Depot4	30	0	30
6	Maggie Simpson	Depot5	20	0	20
7	Milhouse Van Houten	Depot6	20	0	20
8	Ned Flanders	Depot2	25	5	20
9	Otto Mann	Depot3	25	0	25
10	Rod Flanders	Depot5	30	0	30
11	Tod Flanders	Depot1	30	0	30
12	Moe Szyslak	Depot2	20	0	20
13	Homer Simpson	Depot3	20	0	20
14	Fat Tony	Depot4	25	0	25
15	Barney Gumble	Depot5	25	0	25
16	Nelson Muntz	Depot6	25	0	25
Staff

Just an idea.

Good luck.

Ak

 

[Dazzawm]

Thanks Akashwani I have sent you a PM

 

[Akashwani]

Sample data base here....

HolidayChart.xls

Ak

 

[Dazzawm]

Thanks but thats not quite what I am after, has anyone any other ideas please?

 

[Dazzawm]

^