assign end of day to staff vba

R

rakesh seebaruth

Active Member
Joined
Oct 6, 2011
Messages
303
hi guys

I have 10 staffs in a group. Each staff is responsible for the closure of the computerized system at the end of the day. I need a vba code to assign the closure to each staffs.Each staff are entitled two closures per month.Working days are Monday to Friday. Is it possible to have it month wise starting with April 2018
your help will be highly appreciated
rakesh
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

S
  • Question
VBA to automatically populate rolling rota - Help?!
Replies
0
Views
527
samboco
S
M
  • Question
Excel - Identify number of business days for a specific month within a weekly date range
Replies
3
Views
510
duggie33
D
J
  • Question
How to allocate project hours between specific dates using specific daily hour burn rates and including awkward calendar month start/end+holidays
2
Replies
11
Views
1K
felixstraube
F
L
  • Solved
Would like to make edits to VBA Calendar Code
Replies
8
Views
426
Legacy 352679
L
J
  • Question
VBA data table in separate sheet to record data every time the primary sheet is used to assign points to people
Replies
8
Views
479
SonofBelial
S

Forum statistics

Threads
1,215,346
Messages
6,124,417
Members
449,157
Latest member
mytux

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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