Sir, Can you kindly provide a link to download practice file to follow along ,Thanks.
@SahaComputer9 күн бұрын
Happy Independence Day
@MirabelOnyeka-cy9xc12 күн бұрын
Hi sir can you use checkout machine and barcode to scan products that has no barcode number
@kumbukanisaidi534815 күн бұрын
where are the tutorials on how to make this workbook..... please
@vibhuagarwal582324 күн бұрын
To insert every image do me have to do this full coding
@SahaComputer17 күн бұрын
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
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
@rajeevgosavi45142 ай бұрын
Please provide VBA code so that we can copy paste it.
@AndrewStraut2 ай бұрын
hi
@SahaComputerАй бұрын
Hi, How can I help you?
@avinash67762 ай бұрын
But how to find what character I want. It's very time consuming to find manually
@desrajsingh13452 ай бұрын
how the formula you type is showing in right?
@SahaComputer2 ай бұрын
With =FORMULATEXT(A1) A1 should contain formula.
@desrajsingh13452 ай бұрын
@@SahaComputer Thank you
@P_R_I_N_C_E___682 ай бұрын
Have some doubts please can you reply
@SahaComputer2 ай бұрын
Ofcourse
@roshaynesmall22142 ай бұрын
How do we get to watch parts 2 and up?
@SahaComputer2 ай бұрын
Playlist link given in description box
@khawajarizwan70062 ай бұрын
THANKS VERY USEFULL
@SahaComputer2 ай бұрын
You are welcome
@joemargreta66212 ай бұрын
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.
@blkkobra2 ай бұрын
Nice Video sir.
@SahaComputer2 ай бұрын
Thanks and welcome
@cwatiousszara3 ай бұрын
How can I create master shift
@SahaComputer2 ай бұрын
Link given in description box, it is Member video.
@devmangotra91543 ай бұрын
Sir I need 24hrs shift according
@SahaComputer3 ай бұрын
Give me some details.
@SahaComputer3 ай бұрын
Hi, If you have any problem, write me here. I will surely help you.
@devmangotra91543 ай бұрын
Sir mujhe apni team ke liye roaster bnana hai jisme 24hrs employees adjust ho ske.
@mrinalkantitarafder59523 ай бұрын
please create a video of multiple shift attendence sheet
@SahaComputer3 ай бұрын
What do you mean by multiple shift attendance sheet. Please clarify.
@krishnatate47653 ай бұрын
Thank u sir
@SahaComputer3 ай бұрын
Welcome
@SamehFouad-oj4fe3 ай бұрын
In text Label & in Fixed Label the number should be 5,555,250 as the video shows 55,55,250 which is wrong?
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?
@SahaComputer3 ай бұрын
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
@VibhutiGaneshG3 ай бұрын
I have some wrapped text in merged cells. How can I make them scroll vertically?
@SahaComputer3 ай бұрын
Same way but cell reference should be the first cell of the merged cells.
@DrakeSkaggs3 ай бұрын
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!
@SahaComputer3 ай бұрын
Glad it helped!
@ramatasamaya32713 ай бұрын
Please make online learning session of how to make vba coding
@SahaComputer3 ай бұрын
Sure I will
@ramatasamaya32713 ай бұрын
Am waiting for you guidance sir
@SahaComputer3 ай бұрын
Please wait for some few days
@ramatasamaya32713 ай бұрын
And why you Stoping on upload of videos
@SahaComputer3 ай бұрын
Sorry for that. I will start soon
@ramatasamaya32713 ай бұрын
Please complete the series of attendance sheet sir
@SahaComputer3 ай бұрын
I will do it soon
@avanthiboshetti77523 ай бұрын
How f column is filling in auto
@SahaComputer3 ай бұрын
Actually I don't understand what you said. In f column there are many row for which row you are talking about.
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?
@SahaComputer3 ай бұрын
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]
@roshaynesmall22144 ай бұрын
Hi. My dates run from example: 16 March to 15 April. How do I adjust this in the settings?
@SahaComputer3 ай бұрын
Sorry for late reply. There is a option Start Month in Settings Sheet.
@roshaynesmall22144 ай бұрын
Good day. Are you still available to assist? I purchased this via your download link. Awesome skills
@SahaComputer4 ай бұрын
Yes I am!
@Think4real784 ай бұрын
Great stuff.wish i have means to join your channel
@SahaComputer3 ай бұрын
Welcome.
@chhayaraut48814 ай бұрын
Can you share the formula for Second and 4th saturday