• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need VBA to create a new sheet for the duty roaster

bijicha

Member
Hi friends,

Please help me with a Marco, to create a new sheet, with employees name, who is working each day of the month on which shift (M-Morning, A-Afternoon, N-Night, OFF, L-Leave, PO) Attached file, Month sheet have the details which i am creating manually every month and based on that, i need to generate the Result sheet..

Thanks,

bijicha
 

Attachments

  • DUTY ROASTER.xlsx
    25.4 KB · Views: 6
Hi Friends,

Any help please..

My master file have the below,

DATEName1Name2Name3Name4Name5
1-May-21MMOFFMM
2-May-21MMMMA
3-May-21MMMPOL
4-May-21MMMPOL
5-May-21MMMPOL
6-May-21MMMMM

I wish to create another sheet through VBA like below

01-MayDepartmentMANOFFPOL
Name1Name3
Name2
Name4
Name5
02-May​
Name1Name5
Name2
Name3
Name4
03-May​
Name1Name4Name5
Name2
Name3
04-May​
Name1Name4Name5
Name2
Name3
05-May​
Name1Name4Name5
Name2
Name3
06-May​
Name1
Name2
Name3
Name4
Name5
 
bijicha
Based Your samples - press [ Do It ]-button from used Month-tab and You'll get something to Result-sheet.
 

Attachments

  • DUTY ROASTER.xlsb
    32.5 KB · Views: 15
Back
Top