Пікірлер
@rajeevgosavi4514 2 күн бұрын
Sir, Can you kindly provide a link to download practice file to follow along ,Thanks.
@SahaComputer 9 күн бұрын
Happy Independence Day
@MirabelOnyeka-cy9xc 12 күн бұрын
Hi sir can you use checkout machine and barcode to scan products that has no barcode number
@kumbukanisaidi5348 15 күн бұрын
where are the tutorials on how to make this workbook..... please
@vibhuagarwal5823 24 күн бұрын
To insert every image do me have to do this full coding
@SahaComputer 17 күн бұрын
No
@suhailishaq806 Ай бұрын
The clear sheet and copy sheet is mot working for me. I have copied the same code but facing issues mainly with copy sheet and when i save the excel file it does not allow me to save the codes. Please help much appreciated
@SahaComputer Ай бұрын
File type should be macro enabled.
@danieljohn1982 Ай бұрын
If member of staff books 1 day annual leave how do I create this.
@SahaComputer Ай бұрын
In this workbook, there is a Leave sheet, you have to enter there, then in settings sheet you have tick that function on right side of the sheet. then create the roster.
@Shahari Ай бұрын
Why it is not working while it is uploaded to spread sheets
@SahaComputer Ай бұрын
It will work on Microsoft Excel.
@krishnakantthakur9499 Ай бұрын
how to get today rostered shift from whole monthly roster by using formula
@SahaComputer Ай бұрын
Please watch this: kzbin.info/www/bejne/qWO6q5-FpceJpqc
@umeshpandey1293 Ай бұрын
Pls share the steps to make it. Ism fan you. Pls tell how we can make iy
@nancym27 Ай бұрын
Sir, can you provide the practice sheet to us? It'd be really helpful
@rupinderwalia4000 Ай бұрын
your tutorial is wonderfully. i just have a question if we have different people with different rotations we have to input all that differently but how to manage it when the rotations for all the employees is 12 weeks circle and then rotation again repeat for 1-12 and then so on for the whole year. How to go about it
@SahaComputer Ай бұрын
Give a example of rotation style.
@rupinderwalia4000 Ай бұрын
@@SahaComputer employee 1 is permanent full time starts from week 1 On tuesday working tues- friday week 1; Week 2 Works M-thursday week 3 (Monday-Sat); week 4 tues-fri; week 5 (m-fri)week 6 (m-saturday)l week 7 tuesday-thursday; week 8M-friday; week 9 m-sat; week 10 tues- thursday; week 11 M-friday; week 12-M-sat. After this week one starts again and repeats till week 12 and then again till the weeks. there will be 4 other employees which are full time but some start on wed, some on monday Employee 2 is a 0.79 part time starts week 1- tues-friday; Week 2- Mon-thurs; week 3- mon,tues, fri, sat; week 4- tues-friday; week 5 mon,tues, wed; week 6mon, tues, fri, sat; weeks 7 tues-friday; week 8 mon, tues, wed; week 9 mon, frid, sat; week 10 wed, thurs, frid; week 11 mon- thurs; week 12 monday-sat Employee 3 is 0.84 part time starts week 1- M-friday; week 2- mon, tues, frid, sat; week 3- tues, wed, thurs; week 4 mon, tues, friday sat; week 5mon, tues frid, sat; week 6 tues-friday; week 7 monday-thurs; week 8 mon, tues, frid, sat; week 9 tues- frid; week 10 mon-frid; week 11 mon, tues, frid, sat; week 12 tues-thur
@rajeevgosavi4514 2 ай бұрын
Please provide VBA code so that we can copy paste it.
@AndrewStraut 2 ай бұрын
hi
@SahaComputer Ай бұрын
Hi, How can I help you?
@avinash6776 2 ай бұрын
But how to find what character I want. It's very time consuming to find manually
@desrajsingh1345 2 ай бұрын
how the formula you type is showing in right?
@SahaComputer 2 ай бұрын
With =FORMULATEXT(A1) A1 should contain formula.
@desrajsingh1345 2 ай бұрын
@@SahaComputer Thank you
@P_R_I_N_C_E___68 2 ай бұрын
Have some doubts please can you reply
@SahaComputer 2 ай бұрын
Ofcourse
@roshaynesmall2214 2 ай бұрын
How do we get to watch parts 2 and up?
@SahaComputer 2 ай бұрын
Playlist link given in description box
@khawajarizwan7006 2 ай бұрын
THANKS VERY USEFULL
@SahaComputer 2 ай бұрын
You are welcome
@joemargreta6621 2 ай бұрын
Great work... Which part of the video shows if I change the month the inputs will not be the same as the previous month. Thank you.
@blkkobra 2 ай бұрын
Nice Video sir.
@SahaComputer 2 ай бұрын
Thanks and welcome
@cwatiousszara 3 ай бұрын
How can I create master shift
@SahaComputer 2 ай бұрын
Link given in description box, it is Member video.
@devmangotra9154 3 ай бұрын
Sir I need 24hrs shift according
@SahaComputer 3 ай бұрын
Give me some details.
@SahaComputer 3 ай бұрын
Hi, If you have any problem, write me here. I will surely help you.
@devmangotra9154 3 ай бұрын
Sir mujhe apni team ke liye roaster bnana hai jisme 24hrs employees adjust ho ske.
@mrinalkantitarafder5952 3 ай бұрын
please create a video of multiple shift attendence sheet
@SahaComputer 3 ай бұрын
What do you mean by multiple shift attendance sheet. Please clarify.
@krishnatate4765 3 ай бұрын
Thank u sir
@SahaComputer 3 ай бұрын
Welcome
@SamehFouad-oj4fe 3 ай бұрын
In text Label & in Fixed Label the number should be 5,555,250 as the video shows 55,55,250 which is wrong?
@SahaComputer 3 ай бұрын
Please watch at 6:26
@ramkishoryadav9087 Ай бұрын
kzbin.info/www/bejne/q4bTaWSJZdmJq8Usi=8ikVU-0q6FYzRQl_
@iordachecristian5930 3 ай бұрын
Excelent. This what i need. Txh
@SahaComputer 3 ай бұрын
Glad to hear that. Thanks for your comment.
@cherieyung7081 3 ай бұрын
This is very practical. Thank you for the clear guidance. I have 2 questions: 1. how do you add Saturday onto the formula since you already have <> "Sun"? 2. I noticed on the "Copy Sheet" macro it said "Updateby Extendoffice 20160704. Could you please elaborate?
@SahaComputer 3 ай бұрын
Watch this video given below, I think your Saturday problem will be solved. "Updateby Extendoffice 20160704" Ignore or delete this. kzbin.info/www/bejne/hIauaYOOgcuandE
@VibhutiGaneshG 3 ай бұрын
I have some wrapped text in merged cells. How can I make them scroll vertically?
@SahaComputer 3 ай бұрын
Same way but cell reference should be the first cell of the merged cells.
@DrakeSkaggs 3 ай бұрын
Just finish and WOW! You're such a saver. This was an awesome video to follow along with, you made pointers that helped bring the point across.Thank you! To anyone questioning if they are doing it incorrectly, just go back in the video. He shows you how to do it!
@SahaComputer 3 ай бұрын
Glad it helped!
@ramatasamaya3271 3 ай бұрын
Please make online learning session of how to make vba coding
@SahaComputer 3 ай бұрын
Sure I will
@ramatasamaya3271 3 ай бұрын
Am waiting for you guidance sir
@SahaComputer 3 ай бұрын
Please wait for some few days
@ramatasamaya3271 3 ай бұрын
And why you Stoping on upload of videos
@SahaComputer 3 ай бұрын
Sorry for that. I will start soon
@ramatasamaya3271 3 ай бұрын
Please complete the series of attendance sheet sir
@SahaComputer 3 ай бұрын
I will do it soon
@avanthiboshetti7752 3 ай бұрын
How f column is filling in auto
@SahaComputer 3 ай бұрын
Actually I don't understand what you said. In f column there are many row for which row you are talking about.
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/pIqbfJuHmqmInposi=tXLroUnmFKF7MnYQ
@PritamPaul717 4 ай бұрын
Thanks a lot sir ....
@SahaComputer 3 ай бұрын
Most welcome
@derickmartis220 4 ай бұрын
I am excited to buy, but i have a problem. Each of my employees has different week off days. is this covered in the Excel sheet as of today if I buy and download the sheet?
@SahaComputer 3 ай бұрын
Sorry for late reply. we have to add a column in the master sheet and also codes also have to changed. So for that work you have to pay extra. If you agree mail me at [email protected]
@roshaynesmall2214 4 ай бұрын
Hi. My dates run from example: 16 March to 15 April. How do I adjust this in the settings?
@SahaComputer 3 ай бұрын
Sorry for late reply. There is a option Start Month in Settings Sheet.
@roshaynesmall2214 4 ай бұрын
Good day. Are you still available to assist? I purchased this via your download link. Awesome skills
@SahaComputer 4 ай бұрын
Yes I am!
@Think4real78 4 ай бұрын
Great stuff.wish i have means to join your channel
@SahaComputer 3 ай бұрын
Welcome.
@chhayaraut4881 4 ай бұрын
Can you share the formula for Second and 4th saturday