Part 2 - Fully Automated Attendance Tracker with Dashboard in Tamil |Krish's Excel Anywhere|

#Attendance# #Tracker# #Employee# #Students#
I will show you how to create fully automated attendance tracker in excel file with dashboard. This will be useful for companies, schools, colleges and office for those who use attendance. Well explained in Tamil.
I will use the following point while creating this tracker
Create Drop-Down List
EOMONTH
Text
Conditional Formatting
Match, IF, IFERROR, Value
SUM
COUNTIF
Average
Pivot Table
Charts
Slicers
Dashboards
Part 1 video link:
• Part 1 - Fully Automat...
Thank you for contacting Santhu Analytics.
We are happy to assist with your queries and file. Please book the next available 30-minute slot with Santhu Analytics for further support and receive attendance tracker file.
meetpro.club/S...
Please subscribe and don't forget to put Thumbs Up
Contact - 9481829511
Email ID - [e-mail]

[@sabarisanthosh5811]

Romba useful irukku ungaludaiya tracker...

[@SanthuAnalytics9510]

👍

[@azumbasha5201]

Excellent job👍

[@ramajayam.e2348]

Thanks Sir, Nature bless you Sir.

[@kannankalingam3766]

Excellent explanation 👏👏. I Have one doubt. How to give colour using conditional formatting for govt holiday 🙏

[@SanthuAnalytics9510]

Hello, thank you for your valuable feedback and support. I have already posted a video for conditional formatting. Please have a look sir!

[@vijayperumal6084]

Good one as always

[@sureshcm3005]

I really impressed your video and your explanation very good

[@SanthuAnalytics9510]

Thank you for your support

[@saravana3375]

Miga Arumai sir..thank u so much sir

[@SanthuAnalytics9510]

Thank you for your support 👍

[@jayendhiran1]

It s really simple workbook and detailed explanation.. If you explain the macro which is used here that alps will help us on the learning

[@SanthuAnalytics9510]

Thank you for your valuable feedback and support 👍 sure, I will explain in that seperate video

[@perumalammu9579]

Very helpful videos

[@SanthuAnalytics9510]

Thanks 👍

[@sabarishbabu424]

Good job....keep rocking

[@SanthuAnalytics9510]

Thanks a lot for your support 👍

[@pubgkiller9804]

Super bro 👌

[@SanthuAnalytics9510]

👍

[@rj_joseph.rajesh]

Really superb, Thanks a lot bro for ur file which u hav send to my id & response bro

[@SanthuAnalytics9510]

Thank you for your support and feedback 😊

[@seanhayes3225]

Could i please have part 1 and part 2 this looks really useful

[@SanthuAnalytics9510]

Thank you for your valuable feedback and support, I have already posted. I will create one video for macro sir.

[@seanhayes3225]

@@SanthuAnalytics9510 is it possible to have the macro sent via email

[@priyasanthanam1367]

Hi , It was very useful but without the macro update file cannot be prepared. Please update the video for macro. Waiting for your vdo bro.

[@SanthuAnalytics9510]

Hello, Thank you for your support 👍 I will upload in the upcoming weeks

[@priyasanthanam1367]

Hi Sir - Have you uploaded the macro creation for this attendance tracker.@@SanthuAnalytics9510

[@pravinyesudass6758]

Hi Bro, As made by you in this video. Could you Please teach, how to copy the sheet 1 details to sheet 2 by clicking a button?

[@SanthuAnalytics9510]

Hi bro, yes you're right

[@bineetprasadbehera6692]

please can you explain how to export all data in schedule like summary sheet , how can you do it, formula or micro ?thank you ;)

[@SanthuAnalytics9510]

Thank you for your valuable feedback 👍 sure, I will cover that in the future videos

[@Q8iMK]

Thank you for the explanation, very excellent work, I wish you would send me a copy

[@SanthuAnalytics9510]

Thank you for your feedback and support 👍 I have already sent it. Please message me if you haven't received it!

[@louiserobertson6670]

Can you please show how to create the macro which is used in this video to copy the data as it isn't in this video so a little confused

[@sivaprakashn3736]

Hi your videos are awesome. Can you send how to save automatically generated date by using macros. I have sent you the mail. Thanks in advance😊😊

[@SanthuAnalytics9510]

Sure, I will check and confirm 👍

[@sivaprakashn3736]

Thank you for the file bro. Your helping tendency is always moving you towards success.. thank you once again

[@SanthuAnalytics9510]

@@sivaprakashn3736 thanks 👍

[@keerthanar4046]

Hi I have filled out the form could you please share the doc? Thank you!

[@SanthuAnalytics9510]

Hello, sure I will check

[@venkatraina9819]

2007 this excel format not working sir

[@SanthuAnalytics9510]

Hello, I believe it should be supported. May I know which option is not supporting

[@varma7632]

Hi bro i need the fully automated billing software including the stock tracker will you Post the video

[@SanthuAnalytics9510]

Hi, sure I will try my best

[@sarveensangar7067]

Hi brother, Thank you for the explanation. Excellent work! I would appreciate it if you could send me a copy of attendance part 1 and part 2. The attendance sheets can able to do with transportation company. I already emailed you.

[@SanthuAnalytics9510]

Hello 👋 Agree 💯 Thank you for your feedback 👍I will check and send it to you 🙂

[@sarveensangar7067]

@@SanthuAnalytics9510hi brother still I didn’t receive the files

[@varma7632]

Hi bro i want to export employee attendance in the summary sheet yesterday i mailed you please share the file

[@SanthuAnalytics9510]

Hi, I have sent you the file

[@VelMurugan-on3bz]

I need this Excel template, full format

[@lui9486]

Hello! I had messaged you for the macro but did not receive a reply. Please and thank you!

[@SanthuAnalytics9510]

Hello 👋 I will be posting the video this week in this regard

[@prabhakark1754]

hey bro could you please show up the macro process to save the data on the summary sheet

[@SanthuAnalytics9510]

Hey bro sure, can you send me text message to this email id - [e-mail]

[@SanthuAnalytics9510]

Can you confirm?

[@prabhakark348]

@@SanthuAnalytics9510 hey Krish I have mailed you please check

[@SanthuAnalytics9510]

@@prabhakark348 done, just sent it to you 👍 please free to contact during weekend

[@Louiserobertson-s8x]

would appreciate it if you could please share the file.

[@SanthuAnalytics9510]

Hello, Please whatsapp me your email ID 9481829511

[@Louiserobertson-s8x]

Have sent email address via whatsapp as requested

[@hananz1993]

what is button 4? how to export all data in schedule on summary?

[@SanthuAnalytics9510]

Glad to see your response, we use button to run a macro that's written in VBA.

[@SanthuAnalytics9510]

I can you send you the file you need it👍

[@hananz1993]

@@SanthuAnalytics9510 yes , i fill the form response ,i wait file on email

[@SanthuAnalytics9510]

Please send your email id to 9481829511

[@hananz1993]

@@SanthuAnalytics9510 I filled the form data and wait for the file to be sent via email

[@azumbasha5201]

Please share this file

[@yumamageshwari3332]

Sir..enaku january la type pnr datas present absent ellame februarykum paste akuthu ena isuues sir

[@SanthuAnalytics9510]

Are you changing the month on top of the row?

[@yumamageshwari3332]

@@SanthuAnalytics9510 s sir

[@SanthuAnalytics9510]

@@yumamageshwari3332 then need to review the data. Is it happening while copy and pasting the data or in main sheet it self? Can you send me screen shot of issues to this email id - [e-mail]

[@yumamageshwari3332]

Morning send panren sir..but Main sheetla tha panren..main sheet laye ella datasum month wise marurapa change akatha

[@SanthuAnalytics9510]

@@yumamageshwari3332 will check this

[@keerthanar9524]

Full form PH

[@SanthuAnalytics9510]

Public Holiday

[@keerthanar9524]

@@SanthuAnalytics9510 Thank you

[@deennizam]

If change year, not effected start date and end date year

[@SanthuAnalytics9510]

Hello 👋 It should work. Please join the whatsapp group for further support chat.whatsapp.com/DdiP3xLAtpF2QdQYgWOr4E

[@sendhilarunacha5577]

Sir can you send me the attendance tracker excel

[@SanthuAnalytics9510]

Hi Sir, please confirm your email ID? Send it to my email ID

[@sendhilarunacha5577]

Sir i am waiting for file

[@presentfuture516]

hi bro, could you please show up the macro process to save the data on the summary sheet. I have already mailed & also pinged in the Whatsapp.

[@SanthuAnalytics9510]

Hi, I have sent you the file. Please check and confirm

[@SND-ug5zx]

Please send me this file

[@SND-ug5zx]

@@SanthuAnalytics9510 Please send me this file

[@ShankarKumar-cx3ng]

Bro...can you share this sheet to my mail address

[@SanthuAnalytics9510]

Sure, please confirm your email id to [e-mail]

[@ShankarKumar-cx3ng]

I have sent bro....can you check once

[@jeeva3164]

Send me file's

[@SanthuAnalytics9510]

Please send me your email id to the given mobile number

[@IslamicWisdomSL]

Please send me this file

[@SanthuAnalytics9510]

Sure, will do it. Can you confirm your email ID? You can send a text message to [e-mail]

[@IslamicWisdomSL]

Send panni irukkiran

[@SanthuAnalytics9510]

File has been sent

[@hananz1993]

please can you explain how to export all data in schedule like summary sheet , how can you do it, formula or micro ?thank you ;)

[@SanthuAnalytics9510]

Thanks 👍

[@madhunmadhu6608]

​@@SanthuAnalytics9510please share the file,can you please explain how to create macro, Here your not explain about macro

[@SND-ug5zx]

Please send me this file

[@SanthuAnalytics9510]

Hi, please share your email id on whatsapp [phone]

[@SND-ug5zx]

@@SanthuAnalytics9510 i don't have WhatsApp

[@SND-ug5zx]

Can you send it through my email