Attendance Sheet - How to Make Automatic Attendance Sheet in MS Excel in Urdu / Hindi.

[@PAPrincipalSCET]

بہت ہی زبردست لیکچر ہے ماشاءاللہ اللہ پاک آپکو خوش رکھیں اور مزید ترقی عطا فرمائیں امین ثم امین

[@withShahidNaeem]

Thanks

[@TalhaMalik-hw6vt]

Thank you sir G so much ma Allah give a good health in future❤❤

[@withShahidNaeem]

my pleasure

[@ijazhussian7000]

ویری نائس بہت ہی انفارمیشن ویڈیو ہے

[@withShahidNaeem]

So nice of u

[@mubeenmomin7170]

ماشاء اللّٰہ بہت بہترین

[@withShahidNaeem]

thanks

[@MuneebAhmaed]

boht umda sirji smjh agia

[@withShahidNaeem]

Great

[@professorsACADEMY-n6u]

بہت خوب ❤❤❤❤❤

[@withShahidNaeem]

thanks

[@MohsinKhan-hb2js]

Bht Umda G

[@withShahidNaeem]

thanks

[@a.z.acollection1704]

Sir
Sunday ko jesey aap ne auto highlight Kerne ka formula lagaya hey wesey Saturday aur Sunday dono ko highlight Kerne k liyay kya formula lagaye ge

[@muhammadrafi8841]

Sir apki sari videos bht achi hen bht kch seekhny ko mila bus vLookup ka formulae detail k sath btayen please

[@withShahidNaeem]

Discussed in other video

[@MuhammadArshad-gs2ny]

بہت ہی اعلی

[@withShahidNaeem]

So nice of u

[@collegefriends9729]

Beautiful ❤️❤️❤️

[@withShahidNaeem]

Thank you! 😊

[@BilawalSiyal-m3w]

Mashaallah ❤❤ sir

[@withShahidNaeem]

so nice of you

[@Tech-mk7tx]

VERY INTERESTING TOPIC ,AND VERY USFULL

[@withShahidNaeem]

thanks a lot

[@khalidtech7770]

zbrdst sir really appreciated

[@withShahidNaeem]

Thanks for liking

[@rashnamalik8700]

Boht acha smjhaty hai sir Allah apko mazeed kamyabya ata kry

[@withShahidNaeem]

Thanks

[@adilakram81]

VERY INTERESTING TOPIC ,AND VERY USFULL, thank u very much sir

[@withShahidNaeem]

Welcome

[@likeaBoss-Na45haral]

Thanks good working

[@withShahidNaeem]

You are welcome.

[@HajiBashir13]

ماشاءاللّٰه ❤️❤️🕋🕋🌺🌺

[@withShahidNaeem]

thanks

[@AFTABAHMED41]

Good job and thanks a lot.

[@withShahidNaeem]

Most welcome

[@baharali188]

Sir, your excel sheet has been very useful. May Allah give you a long life.

[@withShahidNaeem]

Glad to hear that

[@baharali188]

@@withShahidNaeem Sir, the way the date and day lines of the excel sheet should be stopped, where the attendance is, is like a leftp right scroll.

[@noorsalam6858]

Today Big lesson I learned from you sir tnx❤️🖤

[@withShahidNaeem]

Glad to hear that

[@syblusgamingyt717]

Salute to you sir

[@withShahidNaeem]

My pleasure

[@SikanderBinZain]

Bahot achay bhai...

[@withShahidNaeem]

Thanks

[@ziamalik1339]

Great Sir

[@withShahidNaeem]

Thanks

[@iftikharulhaq669]

Mashallah Sir G

[@withShahidNaeem]

Thanks

[@laracroft5995]

Love you Sir from India

[@withShahidNaeem]

So nice of u

[@ambrinakhtaremblem3754]

very helpfull
thanks

[@withShahidNaeem]

So nice of you

[@etertainment3111]

Thank you sir

[@withShahidNaeem]

Welcome

[@msaqlain1218]

Sir it is very useful..... But please make a sheet which calculates working hours also.

[@withShahidNaeem]

As soon as possible

[@shahidmahmood7046]

well prepared lesson... Mr Shahid ...very nice lecture

[@withShahidNaeem]

Thanks

[@MuhammadArshad-gs2ny]

Nice

[@withShahidNaeem]

Thanks

[@inamullah8965]

Nice bro

[@withShahidNaeem]

So nice

[@asmamajid7649]

JAZAKALLAH

[@withShahidNaeem]

thanks

[@faisalrehman1930]

Respected sir kindly make videos for time keeper job

[@withShahidNaeem]

As soon as possible

[@hiradigitaldesignsolutions3252]

assalam o alaikum sir thank you soo much ap ki video mere liye bohat helpful hai.lekin sir jab main january k mahine main employee ki attendace banata houn to jab february ka mahina open karta houn to us par days aur date to change ho jati hai par jahan jahan january k mahinay main mai ne P,L,A lagaya hota hai wo february k mahine main aur baqi sab mahino main b a jata hai wahan par kya karna parne ga

[@withShahidNaeem]

Save copy of sheet then change month

[@hashmiraza7168]

@@hiradigitaldesignsolutions3252
کیا آپ کا یہ مسئلہ حل ہوگیا

[@asifjoseph508]

Sir jo file hum ready kerty hn, wo save kerny ka method aur use b beta dn. Thanks 👍

[@withShahidNaeem]

same method to save file

[@harisshaikh4973]

sir mujai computer achi tra excel par hath paeda na hai tarika baai

[@withShahidNaeem]

mean?

[@asadraza6474]

Sir AK month fill karta hn to next sare month same wese he HojTe fill mtlb agr janury ki 1 date ko present lagao to wo baqi sare month ki 1 ko b Presnt he show kartaa

[@asadraza6474]

Plz guide

[@withShahidNaeem]

its better to watch video without forwarding, you will find error

[@asadraza6474]

Sir forward kiye bagair he dekhii haj

[@jackyjigs2498]

Same problem plez guide us in this matter.. When I put P, A in Jan month same text is apearing in next month also..

[@professorsACADEMY-n6u]

Sir koi automatic fee record sheet Ka videos B upload kr dejya ga

[@withShahidNaeem]

Good Idea! Will try to make one.

[@zamgardeningsolutionpk]

good

[@withShahidNaeem]

Thanks

[@zamgardeningsolutionpk]

@@withShahidNaeem I have gardening exper

[@zamgardeningsolutionpk]

your method is too good i work in excel

[@zamgardeningsolutionpk]

I had been subscribe your channel

[@444aqeel]

aoa. sir. agr month change ho tou us k lehaz se sheet ki present/leave status change ho jana chahiye. lakin wo change nahi hota. kindly is ka bata dain. k month k lehaz se data change ho accordingly.

[@withShahidNaeem]

You can make copy of sheet

[@aburafay2226]

السلام علیکم ورحمتہ اللہ وبرکاتہ
سر میں نے حاضری شیٹ بنائی ہے اچھی ہے لیکن ایک مسلہ ہے کہ جس مہینہ کی آپ حاضری لگاتے ہیں جب مہینہ تبدیل کریں تو پچھلے ماہ کی حاضریاں شو ہو جاتی ہیں مگر ہونا تو ایسے چاہئیے کہ جس مہینہ کی حاضری لگائیں وہ دوسرے مہینہ میں شو نا ہو بلکہ ہر مہینہ کی الگ الگ حاضری شو ہو تا کہ سالانہ ریکارڈ محفوظ رکھا جا سکے

[@aburafay2226]

مہربانی فرما کر اس کا حل بتائیے گا

[@withShahidNaeem]

Then u have to move them in excel sheet using b
Vba

[@aburafay2226]

اگر آپ ہیلپ کریں تو میں سب کچھ کر سکتا ہوں مجھے ایک ایشو رہتا ہمیشہ کہ میرے پاس ایپل میک بک ہے شاید کچھ مختلف ہو ونڈو سے مگر میں اب تو کامیاب رہا اس کے بعد ڈیٹا انٹری پہ پھنسا ہوا ہوں

[@samrazaidi5581]

Sir how can we save all month's data in one tab? Like you showed in the beginning how you select any month from the drop down list and it shows it's data accordingly.

[@withShahidNaeem]

You need to learn VBA for this

[@samrazaidi5581]

@@withShahidNaeem Do you have any video on VBA Sir? Could you please share any link. Would be helpful. I also wanted to learn a few more methods of recording company data on excel. Is there any official email address where I can share the details

[@zainabsohail04]

Hello sir if we want to set that red color that shows leaves status on Saturday as well what to do ? Could u pls guide ?

[@withShahidNaeem]

Set formats from conditional format

[@harrisahmed866]

Target vs achievement b bana k dikhain pls

[@withShahidNaeem]

inshallah soon i will try

[@rashidqazi607]

sir agr Hamary pas wrker k rest day alag alag h for example kici ka fri h kici ka Sunday Kici Ka wed to kis tarha Aik Hi Baar Mai Condition de gy

[@withShahidNaeem]

Manually kerna paray ga

[@dardeinsaniyat3257]

Sir jo log mid May resign kr jaty hain ya new entry krni hoti hai tu oska kiya tareeqa kaar hoga ? I mean to say k let's suppose ik employee March may aya hai tu oska name January or February may nahi ana chahiye jb hm drop down sy month change krty hain...

[@withShahidNaeem]

you should have extra rows for new employees and you can start attendance from date of joining

[@jackyjigs2498]

When I put P, A in Jan month same text is apearing next month.. Plez guide me in this..

[@withShahidNaeem]

Next month u need to clean list again

[@GyanBLimbu-xh9zs]

@@withShahidNaeem so how can we save data in each month?

[@mkhalidjaved1841]

Sir
Mujy attends sheet mein P Present lekny say current time or A Absent lekny say time zero zero show kary ye kesy ho ga kindly rehnumai farmain
Thanks Jazak Allah

[@withShahidNaeem]

Better to watch video again u will find error

[@freindvlogs]

Jb hm month change krty ha to nichy sy attendance ka data b change hona chahiye Kisi month m new name add Kiye ha wo b

[@withShahidNaeem]

Then include VBA code

[@abdullahceylani3637]

ASSALAMOALAİKUM G
SİR ABHİ 2024 START HO RHA HAİ TO İS MEİN AUTO 2024 HO JAYE GA YA PHR CHANGE KRNA PARHY GA
İS K BARY KUCH MALOOMAT DY DEİN PLZ...

[@withShahidNaeem]

you need to change

[@naeembajauri6230]

Salam sir
Sir agar hm is me late comers ke lye time mukhtas katenge wo kese hoga ao late comers ki deduction kesi hogi

[@withShahidNaeem]

same like absent but you can divide it with 2 to make half deduction

[@arifghori7683]

asalam alikum sir, sir moth list is doing ..drags and drop is not is working properly

[@withShahidNaeem]

Try again

[@arifghori7683]

@@withShahidNaeem yes sir i try

[@arifghori7683]

i done sir, and thank you

[@seharisrar8731]

Sir Meri dates drag Ni ho rhi . I tried many times

[@basharatnauman1904]

Janab ager hum aik sheet pe kuch add krty hai toe wo sb month mein add ho jata hai aur waha. Se delete kry toe pervious bhe delete ho jata hai kindly sheet lock krny ka tariqa btye k aik month mein he add ho second month mein hum khud attendance khud lagye

[@withShahidNaeem]

Sheet copy ker lian

[@roziali3637]

Sir January ky month ma attendenc lagadi or month complete howa. February Ky month ma new sheet ya blank nai Arayhe

[@withShahidNaeem]

New sheet banian gay

[@roziali3637]

@@withShahidNaeem ksay banayingy phely sy bani h.

[@worldfor5867]

Sir can you tell me about Accounting work?
How we can face accounting jobs ?

[@withShahidNaeem]

every thing can be managed through excel

[@naeemhassan5400]

salam sir can u make fully automatic attendance sheet between two date like 26-01-2022 to 25-02-2022.please sir help me

[@withShahidNaeem]

yes watch video

[@naeemhassan5400]

Sir I watched that one video but there is no solution in this video. But my start date 26 jan-2022 to 25 feb-2022. Whenever I used formula there coming error.

[@MuhammadHanif-dg1iy]

Sir g ham jis month may APL lagathy Hy to yahee farmat doosry month may b athi Hy her month main apny apny format kasy save kar sakthy hy

[@withShahidNaeem]

make different sheets

[@MuhammadHanif-dg1iy]

@@withShahidNaeem sar ji agar different sheet banana hi hai to fir manth wale Kalam ko banane ka kya fayda

[@MuhammadHanif-dg1iy]

Sir, if another sheet is to be created, then what will be the benefit of adding the names of 12 months in the month column

[@azizullahkhan2126]

Sir hum excel mai apni marzi sy kisi bhi type ka formula kesay bna skty hain,for example jesay ap koi bhi formula situation k hisab sy bnaty hain.kindly excel mai all formulas shortcut ki detail video bna dein..

[@withShahidNaeem]

Watch if function video

[@adeelqasim3245]

Aoa sir is main ye problem a raha he ke ager hum jan main data ad karte han tu wo fab main show hota he aur jab feb se delete karin tu wo jan se bhi delete ho jata he is ka kia hal he

[@withShahidNaeem]

Watch video carefully step by step. U will find error

[@AbdulHaq-v1r]

Sir pls. make a weekly attendence and per day salary sheet

[@withShahidNaeem]

You should learn to make with the help of this video

[@AbdulHaq-v1r]

@@withShahidNaeem Sir it is monthly sheet i need weekly

[@AbdulHaq-v1r]

@@withShahidNaeem thaks a lot sir

[@scskazmi9674]

Sir when i delete months sheet extra all month is not show in the collom why.

[@withShahidNaeem]

Each month is linked with other

[@raomoeed7781]

Sir es main problem y arhi h k agr jan ki attendance put krty hain to wo sb month main show ho rha h hr month ka alg hona chhy es k ly guide kren please

[@withShahidNaeem]

Her month ki alag ho

[@raomoeed7781]

@@withShahidNaeem G bilkul sir .....please solve solution

[@raomoeed7781]

Means k isi sheet main hr Month k attendance hn

[@MFKofficial24]

Same problem sir kindly give solutions immediately

[@SamiUllah-th1gq]

اَلسَلامُ عَلَيْكُم وَرَحْمَةُ اَللهِ وَبَرَكاتُهُ

[@withShahidNaeem]

Wa alaikum salam

[@SamiUllah-th1gq]

@@withShahidNaeem Sir kindly give me mob no. me buhut ziyada nahi samajta. Molana Sami ullah.

[@nileamusementconsultant9623]

koi help krsksta hai date formula likhnay kai time month e4 kaisay slect krna hai ??

[@withShahidNaeem]

watch video again carefully

[@neeltravelstours4092]

@@withShahidNaeem 3 dafa dekh chuka hon laikin month ka cell select nhe hota copy bhi kai cursor sai bhi laikin nhe hua select

[@neeltravelstours4092]

any short key ??

[@sarfarazsyed5532]

SIR IS VIDEO MEIN KUCH MISING HAI JESE KE SELECT MONTH MEIN KOI BHI MONTH SELECT KARTE HAIN TO P,A,L WAHI SAME CELL MEIN ARAHE HAIN

[@withShahidNaeem]

You can make its copy

[@manzoorahmedshah6950]

when we change month new sheet open with out fill

[@withShahidNaeem]

It's possible. Just think

[@manzoorahmedshah6950]

@@withShahidNaeem HOW .....i make one sheet i change month but only sunday highlight change ....not a blank sheet ...

[@rashidhussain1306]

Sir agar colour Chang Karna ho kasa karty hain Red ki jga koi or change Kara ho kasa Karna ha

[@withShahidNaeem]

You can change from properties

[@RoNaKHere-x4x]

Assalamu Alaikum.
Maine pata nhi kahan mistake kiya lekin kusi month me 1 cell me (A/P/L) likhne par sabhi month k us cell par wo likha hua aa rha h... How to fix...
Maine windows 7 par ye attendance sheet banaya hai..

[@withShahidNaeem]

actually i can not under stand your problem

[@gntactics9154]

@@withShahidNaeem jab hum January ki month main (present, absent,leave) lekte hain tou sub month main aik jaisa hota haon...
har month main alag alag present absent kaisa hoga sir

[@sonamekka1827]

Thankyou so much

[@akhtarrasool7794]

Sir me ne excel me devlpr tap add kr lia ha but visual basic r macro abi b disable hn

[@withShahidNaeem]

Save file as macro enable work book. See macro video

[@SuFyanAnsari01]

sirf Excel ka setup mil sakta ha??

[@withShahidNaeem]

CONTACT AT WHATS APP

[@Iqbaljaved223]

Assalamoalaikum sir
I make this sheet. It is very useful but when I recorded data in 1 month it shows in all months and if I delete data from 1 month data also delete from all months. Please Help

[@withShahidNaeem]

save its new copy for next month in same workbook as a new sheet

[@Psxwale6705]

Agar 100 worker he our her 1 worker ki weekly rest different he khuch worker rest Kerty he khuch over time lagatay he Sir,uska keya method ho ga sir?

[@withShahidNaeem]

Learn from this video

[@neeltravelstours4092]

Aacha sir agr hum off friday sat or sun off dena chahtay hain phir kaisa formula hoga

[@withShahidNaeem]

Same procedure

[@adilahmed1438]

sir agar january month ka attendance mark kar hon wo attendace sary month me mark ho rahi hai mujhe sirf january me mark karni hai is ka solution bataein

[@withShahidNaeem]

re watch this video and practically do work you will get solution

[@Mannanmalik66]

السلام علیکم سر
باقی سب ٹھیک ہے لیکن۔۔ حاضری کا ریکارڈ بھی ہر ماہ کا تبدیل ہونا چاہیئے۔ اتوار کے دن وغیرہ تو چینج ہو جاتے ہیں لیکن حاضری چھٹی۔۔۔ کا ڈیٹا وہ وہی رہتا ہے

[@withShahidNaeem]

Copy sheet for new month

[@ZeibaMalik]

Sir main ny attandence sheet banai hai month change hoty hain hain lakin sheet change change ni hoti please help me

[@withShahidNaeem]

Save as new worksheet

[@ZeibaMalik]

@@withShahidNaeem sir masla ye hai November ky 30 day hain present bhi 30 hain jesy December change kerta hon to attandence sheet wohi 30 din a rehy hain date change ho rehi days bhi change horehy hain lakin sheet change ni hoti

[@shahidmahmood7046]

Plz, guide us....how to calculate total absent, present, leave etc per day...?

[@withShahidNaeem]

Formula is in video. Watch carefully

[@shahidmahmood7046]

@@withShahidNaeem
Send me your email..I will send my attendance sheet and discuss with you the problem I am facing

[@AdnanKhan-us8sq]

Aslam o Alaikum sir agar kisi k double present hon over time ho tu kasy manage krn

[@withShahidNaeem]

Get idea from other related videos

[@atz527]

Sir mny count if wala formula absent pr lgaya ha pr formula nhi lga

[@withShahidNaeem]

Watch video again

[@harrisahmed866]

Sir how to remove privious deta like P A in sheet

[@withShahidNaeem]

Make a duplicate file with Save As then remove it for next month

[@harrisahmed866]

Thanks alot.

[@ambreensadiq]

how can u edit a formula an d lock it

[@withShahidNaeem]

F2 is used to edit any cell

[@ambreensadiq]

thankyou so much sir

[@usmanmustafa816]

Bhai agr 26 sa start date oendin 25 krni ho to uska farmula kaisy lgye gy

[@withShahidNaeem]

Same formula . Watch vid again

[@sardarkhan-sz2tg]

Sir ya to makhsos logo ki sheet ha?

[@withShahidNaeem]

Then ?

[@aameermukhtar6800]

Sir.how change the year

[@withShahidNaeem]

Same way

[@mustansirnabi779]

Har month mai yeh khud se attendance kyun mark kar raha hai? Yeh baki month mai toh attendance nai dekhana chahiyai na? Plz help

[@withShahidNaeem]

U need to learn vba

[@professorsACADEMY-n6u]

Sir date KO aga grab krta ho 00 date ata ha why is this.

[@withShahidNaeem]

Watch video again

[@F.Rahman-79]

the formulas you are using in this work sheet is aplicable in excel 2007, please guide how to use it in 2007

[@withShahidNaeem]

You can use

[@usamajutt3005]

@@withShahidNaeem mary pass excel 2007 ha jo month wala drag ha wo us ma 2nd sheet open nhe ho rje

[@pazubair5428]

Sir when we selecting nov month, then all cell are became red like sunday. And sir we start from 21 of every month and end 20 of every month so next moth is not showing by changing month. Plz guide further

[@withShahidNaeem]

Write 21 instead of 1 in start date

[@withShahidNaeem]

Watch video carefully and at start date place 20 inplace of 1

[@MohdImran-lr2nf]

Sir Months ke sath data nahi change ho rha hai

[@withShahidNaeem]

U need to learn macros

[@OOZZII_VIEWS]

Sir yahn pr over time Nahi hy

[@withShahidNaeem]

means?

[@hiramaani9736]

Assalam o alikum mery computer may option nahi a arahay

[@withShahidNaeem]

please tell me clearly , which option ?

[@saadmian5368]

Agar is ma koi holiday add karni ho to

[@withShahidNaeem]

us ko manually highlight ker lian

[@saadmian5368]

@@withShahidNaeem tora sa guide karay kaisa q ka sheet ma editing nhi ho rahi hai

[@Bengali-food2029]

Sir main date year ko barana chata hon kyse baru pls

[@withShahidNaeem]

Explain your question

[@Bengali-food2029]

@@withShahidNaeem sir aap attendance sheet ke Ander Jo datevalue formula use Kiya oo by default 2023 ke ae raha hai wo change kyse koron

[@Bengali-food2029]

Please answer me sir

[@professorsACADEMY-n6u]

Dollar sign laga kr frize be phr B grab krta hova 00 date araha ha

[@withShahidNaeem]

Watching video again carefully

[@harisshaikh4973]

sir je attendas sheet par ending date par fumuly mai = if (e7 < ,e7+1" ") o4 ki jaga kya fumula lagaya sir lzz jaidi jwab dy

[@withShahidNaeem]

sorry i can not understand , what you want to ask

[@GyanBLimbu-xh9zs]

Any idea please guide me

[@withShahidNaeem]

Idea about what?

[@FahadKhan-yy4zh]

❤️‍🩹 well done sir

[@withShahidNaeem]

thanks

[@FahadKhan-yy4zh]

One problem when we select another month except current month present and absent not change

[@hazratakbar2842]

Sir g Total working days formula ......?

[@withShahidNaeem]

countif function is used for this purpose

[@hazratakbar2842]

For example...?

[@NONOSURUvlogs]

But tha main i want to say is when I change ta month it was not change your P, A, S

[@withShahidNaeem]

?

[@GyanBLimbu-xh9zs]

what i saved in Jan are appearing in Feb and all next months and i have to delete my previous data .so it is not effective

[@withShahidNaeem]

Make its copy with save as