works Holiday Calander

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
I applogise for not showingto a screen shot....to thick work it out.

Sheet1
I have a calander that changes dates etc on change of month

for each week i have three rows

row 1 date
row 2 is blank and will have a h or H input
row 3 is a count of those hols previously input to show haow many off.

Sheet2 has dates running in column A by single date for about 10 years
with person id running columns B to amount of staff.

I then intend for people to select an employee id and see his chart for a year.

on input to calander the person selects month and types emp.id in a cell

I've got most of it worked out in my head and am happy to do all the ruturn stuff by simple formulas.

There is a question here somewhere......

What code do I need to run on pressing a save button to get the H's to hard code as 1's on page 2 for the employee and date?
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
Ok I decided to not be too thick to work it out....

HTML:
[RANGE=cls:xl2bb-100][XR][XH=cs:8]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]C[/XH][XH]D[/XH][XH]E[/XH][XH]F[/XH][XH]G[/XH][XH]H[/XH][XH]I[/XH][/XR][XR][XH]2[/XH][XD=h:l|bc:33cccc]Month[/XD][XD=h:l|bc:33cccc]Employee[/XD][XD=h:l|bc:33cccc]Taken[/XD][XD][/XD][XD][/XD][XD=h:l|bc:333333|c:ffffff]Save[/XD][XD][/XD][/XR][XR][XH]3[/XH][XD=h:l|bc:ccccff]January[/XD][XD=h:r|bc:ccccff]3124[/XD][XD=h:r|bc:ccccff]18[/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]4[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]5[/XH][XD=h:l|bc:ccccff]Sunday[/XD][XD=h:l|bc:ccccff]Monday[/XD][XD=h:l|bc:ccccff]Tuesday[/XD][XD=h:l|bc:ccccff]Wednesday[/XD][XD=h:l|bc:ccccff]Thursday[/XD][XD=h:l|bc:ccccff]Friday[/XD][XD=h:l|bc:ccccff]Saturday[/XD][/XR][XR][XH]6[/XH][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][XD=h:r|bc:ccccff]1[/XD][/XR][XR][XH]7[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]8[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]9[/XH][XD=h:r|bc:ccccff]2[/XD][XD=h:r|bc:ccccff]3[/XD][XD=h:r|bc:ccccff]4[/XD][XD=h:r|bc:ccccff]5[/XD][XD=h:r|bc:ccccff]6[/XD][XD=h:r|bc:ccccff]7[/XD][XD=h:r|bc:ccccff]8[/XD][/XR][XR][XH]10[/XH][XD][/XD][XD][/XD][XD=h:l]H[/XD][XD=h:l]h[/XD][XD=h:l]h[/XD][XD=h:l]h[/XD][XD][/XD][/XR][XR][XH]11[/XH][XD][/XD][XD][/XD][XD=h:r]3[/XD][XD=h:r]4[/XD][XD=h:r]3[/XD][XD=h:r]2[/XD][XD][/XD][/XR][XR][XH]12[/XH][XD=h:r|bc:ccccff]9[/XD][XD=h:r|bc:ccccff]10[/XD][XD=h:r|bc:ccccff]11[/XD][XD=h:r|bc:ccccff]12[/XD][XD=h:r|bc:ccccff]13[/XD][XD=h:r|bc:ccccff]14[/XD][XD=h:r|bc:ccccff]15[/XD][/XR][XR][XH]13[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]14[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]15[/XH][XD=h:r|bc:ccccff]16[/XD][XD=h:r|bc:ccccff]17[/XD][XD=h:r|bc:ccccff]18[/XD][XD=h:r|bc:ccccff]19[/XD][XD=h:r|bc:ccccff]20[/XD][XD=h:r|bc:ccccff]21[/XD][XD=h:r|bc:ccccff]22[/XD][/XR][XR][XH]16[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]17[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]18[/XH][XD=h:r|bc:ccccff]23[/XD][XD=h:r|bc:ccccff]24[/XD][XD=h:r|bc:ccccff]25[/XD][XD=h:r|bc:ccccff]26[/XD][XD=h:r|bc:ccccff]27[/XD][XD=h:r|bc:ccccff]28[/XD][XD=h:r|bc:ccccff]29[/XD][/XR][XR][XH]19[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]20[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]21[/XH][XD=h:r|bc:ccccff]30[/XD][XD=h:r|bc:ccccff]31[/XD][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][XD=bc:ccccff][/XD][/XR][XR][XH]22[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]23[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=cs:8][RANGE][XR][XD]Sheet1[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]
 

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
Right, I am too thick,

Any suggestions on what I did wrong there?
 

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
I missed a step,

OK so I am looking to save the H's as described above but also in thinking about it when I key in this persons number his H's need to re=appear on that line so I can delete them if he/she cancels


Sheet1


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 69px"><COL style="WIDTH: 64px"><COL style="WIDTH: 80px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="BACKGROUND-COLOR: #33cccc">Month</TD><TD style="BACKGROUND-COLOR: #33cccc">Employee</TD><TD style="BACKGROUND-COLOR: #33cccc">Taken</TD><TD> </TD><TD> </TD><TD style="BACKGROUND-COLOR: #333333; COLOR: #ffffff">Save</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="BACKGROUND-COLOR: #ccccff">January</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">3124</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">18</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">4</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">5</TD><TD style="BACKGROUND-COLOR: #ccccff">Sunday</TD><TD style="BACKGROUND-COLOR: #ccccff">Monday</TD><TD style="BACKGROUND-COLOR: #ccccff">Tuesday</TD><TD style="BACKGROUND-COLOR: #ccccff">Wednesday</TD><TD style="BACKGROUND-COLOR: #ccccff">Thursday</TD><TD style="BACKGROUND-COLOR: #ccccff">Friday</TD><TD style="BACKGROUND-COLOR: #ccccff">Saturday</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</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">8</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">9</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">5</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">6</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">7</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">8</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD> </TD><TD> </TD><TD>H</TD><TD>h</TD><TD>h</TD><TD>h</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">2</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">9</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">11</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">12</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">13</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">15</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</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">14</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">15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">16</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">20</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">21</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">22</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</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">17</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">18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">23</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">24</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">25</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">26</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">27</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">28</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">29</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</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> </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">21</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">30</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">31</TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</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">23</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>
 

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
I'm sure I have seen this or do I need to

1. Create individual sheets for each person and look up master table from there?

2. Create the form in some form of input box.

3. Is the answer as simple as when pressing the save button I save sheet2?
 

Forum statistics

Threads
1,141,849
Messages
5,708,973
Members
421,602
Latest member
jkpce1880

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
Top