Thanks for sharing and teaching excel tips.. Its very useful for me and I am adopting this table for my Dairy Farm.. Request you to make an excel which is applicable for Dairy Farm Management if possible..
Jitendra, Couple of things you can add to make this format really powerful. 1) Add Holidays on top of Days. 2) For weekoffs, provide the option. Provide 2 cells for Weekoffs and people can select weekoffs from the dropdown. Whatever days they will select, those specific days will be highlighted. 3) Also highlighted the columns from 1st employee to the last employee for Holidays For 2nd date, eomonth can be used to avoid the criteria of iferror. I watch almost all your videos. Nice teaching style. Keep up the great work
Very nice sir, Thanks❤ Sir, yadi month me aane Wale any avkash ke dino ko is prakar se lock Kiya Jaa sakta ho to use bhi batane ka kasht kare. School me students ki attendance ke liye upyogi hoga.
Hi Jitendra Ji, Thanks for sharing this. But while modifying one month's attendance (P/A) data, another month's data is automatically getting changed or modified. How to fix this? Please guide
Dear sir, How to use present sbsent dropdown list in attendance sheet without Sunday. I want dropdown not showing in Sunday. Sir please tell me how can I do this. Dear sir I'm longtime flowing you from Bangladesh.
sir employees ke TA/DA lekey ek video banahe jin men all employees record manage in a sheet details are >>> 1. Departure place, 2, date aor date ky below time, 3. Arrival place, 4. date and below time, 5. purpose of jurney, 6. KM, 7. rate, 8. day, 9. daily, 10. amount, 11 total amount. for 15 days. TA/DA with vloookup formula style. because i will every month make one by one employee. it is very hard work, so please make a video use these step in one sheet.
This format is just for one month. For 12 months you will have to create 12 sheets. In case you want to blank or delete the data, you can do it manually or can use Macros
Ek question tha For ex_Jab v hum kisi ek particular Month select krte hai, aur attendance sheet Wale cell mai kuch v data type krte hai, Toh wahi same data har month k sheet mai show ho Raha hai, Hum chahte hai ki woh data sirf ek hi particular Month k sheet mai show ho, na ki har month k sheet mai,
Sir ek chez ap NY nhi batai har month Ka data save kesy Hoga Banaya but har month me wahi data same araha he manually remove kr Raha ho me plz give me solution.
Sir ab aap ye bataye hume agar hum is sheet me month change kare to absent aur present fill kiya hai woh show nahi hona chahiye jis month ka data humne fill kiya hai kewal us month ka data show hona chahiye agar aisa hota hai to hum ek hi sheet me 12 month ka data bana sakte hai aur dekh sakte hai month change kar kar ke Agar aisa ho sakta hai to ek video upload kare
@@PowerExbyJitendra Sir, when I change for the next month ,the data is automatically filled there from the previous month and if I am removing that, the previous month's data is also getting deleted.Can you please guide how to fix the problem..?