Use of check box for employee schedule

[rizmomin]

Hello:

Please refer to attached sheet.

I want to do employee scheduling using excel.

I would choose the name of the employee from dropdown list in cell A3 and date from dropdown list in cell B3
Then i would use 1 check box for Clockin time from cell Range D3:D16 and 1 check box for Clockout time from cell Range G3:G16.

Now i would need an UPDATE button which will paste the Clockin-Clokout for the selected employee in the corresponding cell Range L3:AP25 in XXXX-YYYY format where XXXX is the value from D3:D16 and YYYY is the value from G3:G16

Also UPDATE button should clear check boxes for the next entry after the XXXX-YYYY is pasted.

Please let me know if any questions.

Thank you

Riz

[rizmomin]

Hi :

Can someone please help me with this.

Please let me know if any questions.

Thank you

Riz

[rizmomin]

Hello:

I am changing the format little bit so please ignore previous requirement.

Please refer to attached sheet.

I want to do employee scheduling using excel.

I would choose the name of the employee from dropdown list in cell A3 and date from dropdown list in cell B3 in MonthlySch Sheet.
Then i would use 1 check box for Clockin time from cell Range D3:D16 and 1 check box for Clockout time from cell Range G3:G16.

Now i would need an UPDATE button which will paste the Clockin-Clokout for the selected employee in the corresponding cell Range K:AG in XXXX-YYYY format where XXXX is the value from D3:D16 and YYYY is the value from G3:G16

Also UPDATE button should clear check boxes for the next entry after the XXXX-YYYY is pasted.

Please let me know if any questions.

Thank you

Riz

[watersev]

hi Riz, option

[rizmomin]

Hi Watersev:

Thank u so much for your help and this works.
However i just changed the little bit of my requirement as you can see in Book1.xls i uploaded few min back.
I am very sorry but would love your help on this.
The difference is that i would prefer to have emploees in ROW and Date in column as seen in Book1.xls

Please let me know if any questions.

Thank you

Riz

[watersev]

please check attachment

[rizmomin]

Hi watersev:

Works great, except when we update, the checkbox in column G does not reset.
Would also need to make sure that only 1 check box would be allowed in Column D & G.

Also, next step i need is to populate this data in Weekly_Sch Sheet, probably by formula.
Please refer to the same updated attached file.
Please let me know if any questions.

Thank you

Riz

[watersev]

please check attachment

[rizmomin]

Hi watersev:

It works just i wanted.
Would it be possible to add Confirmation.
After pressing update button, If it can show the Name, Date, Day, ClockIN time, ClockOut Time.
Yes, No, Cancel.

Also i am adding a column Choose Date and ClockIN
Column C would be the day and i will have formula there =TEXT(B3,"ddd")

Please let me know if any questions.

Thank you

Riz

[watersev]

I've changed the code to account for all possible error options, please check attachment

[rizmomin]

Hi watersev:

I am getting error if the date is < 5/5/2013.
Please check and let me know.

Thank you so much for your great help.

Thank you

Riz

[rizmomin]

Hi watersev:

I think i have figured out the problem.
works great


Thank you so much for your great help.

Riz