Love it. Thank you so much for sharing. Your training is very thorough and so easy to follow. ❤

Beautiful, nice work man! Thank you!

@PKAnExcelExpert

6 ай бұрын

Glad you like it!

As usual stunning

@PKAnExcelExpert

6 ай бұрын

Thank you! 😊

Check box can not be inseted. There is no facility in Inser tsb to insekto check box. I tried with Developer tab, but not getting accurate answ. And even I tried to include one check box , it is not getting Counter in present Count. Please guide.

@josephkiley525

22 күн бұрын

The specific feature this video is centered on is currently unavailable in Excel. This can mostly all be done with the Form Control checks but it takes significantly more work and is tedious. Worth it, but tedious. And the checks don’t change color that I’m aware of.

thanks for this stunning and practical video.

@PKAnExcelExpert

16 күн бұрын

Most welcome

Great tutorial 👌 thank u PK

@PKAnExcelExpert

6 ай бұрын

Most welcome

Good one... Thank you

@PKAnExcelExpert

6 ай бұрын

Welcome 😊

Thank you so much Sir

@PKAnExcelExpert

6 ай бұрын

Most welcome

Legend

Quite explanatory and easy to follow. but it is not dynamic with subsequent months

Sir, how can I insert checkbox like you. Plz guide

Hi, I tried the same and I am getting error = datevalue(concat("1",H3,S3)) its coming as value error. How come H3 is month and S3 is year.

why when you change the month or year the data will still the same and will not change.

If you select another month or year, is it not supposed to display empty checkboxes? It still displays the information of the previous month. How to solve this problem please explain

@ad-infinitumolu1372

3 ай бұрын

Thats what I thought too. Any idea on how to make it dynamic?

@danielsanta3922

Ай бұрын

Has anyone figured this out?

@michaeldingee743

Ай бұрын

Try this Insert a module and and copy the code Sub ClearRange Sub ClearRange() Dim LastRow As Long Worksheets("Attendance").Activate LastRow = Worksheets("Attendance").Cells(Rows.Count, 36).End(xlUp).Row 'MsgBox LastRow wsIn.Range("D7:AH" & LastRow).ClearContents End Sub 'Right mouseclick on the Attendance Sheet and select View Code,copy the code Below. I Renamed the sheet to Attendance,change (Target, ActiveSheet.Range("C3")) change cell C3 to the correct cell that is changing Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then GoTo done If Application.Intersect(Target, ActiveSheet.Range("C3")) Is Nothing Then GoTo done 'Call CopyColumns Call ClearRange done: End Sub

@michaeldingee743

Ай бұрын

'Try this 'insert a module and and copy the code Sub ClearRange Sub ClearRange() Dim LastRow As Long Worksheets("Attendance").Activate LastRow = Worksheets("Attendance").Cells(Rows.Count, 36).End(xlUp).Row 'MsgBox LastRow wsIn.Range("D7:AH" & LastRow).ClearContents End Sub 'Right mouseclick on the Attendance Sheet and select View Code,copy the code Below. I Renamed the sheet to Attendance,change (Target, ActiveSheet.Range("C3")) change cell C3 to the correct cell that is changing Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then GoTo done If Application.Intersect(Target, ActiveSheet.Range("C3")) Is Nothing Then GoTo done 'Call CopyColumns Call ClearRange done: End Sub

Hello PK, I'm very happy to discover your KZread channel. Have you ever made tutorials for YTD progress tracking of tasks. Thank you

@PKAnExcelExpert

5 ай бұрын

Will upload soon

what if the mark is only for the absent and the unmark will mean present how will u make the command?

How did you insert the check box can you please explain..!?

@MohamedAzeed-lc6cr

2 ай бұрын

Yeah I'm using 2019 office it hard to insert the check box

thanks. but i want the month start from this month 26 to next month 25 please help

when we add the data in the month of Jan the same data automatically gets in the other months till Dec. whats the solution for that? anyone, please guide me

Hi how much you make the attendance sheet excel?

❤❤❤❤❤

@PKAnExcelExpert

6 ай бұрын

Thanks 🙏

@vishnuvamshi4645

6 ай бұрын

​@@PKAnExcelExpertwhat about weekend days ?

In 2019 office how can i manage the checkbox same like this

Nice work! Could you make a year calendar 🗓️ month wise with holidays and weekends marked red on it with holidays level on the date, in excel. It will be really helpful for we office employees to plan our holiday. I hope you consider my request. Thank you

@PKAnExcelExpert

5 ай бұрын

will upload today.

I have combined more than one worksheet into one worksheet. If I search, for example, for a specific name that is present in more than one worksheet, I want to show the name of the page where the name is located. If possible, there is a way to show the name of the worksheet in the comment property.

Check box isn't working sir! Which version of excel are u using

How to hide weekdays in this ?😢

Sir first i made for January month if I am filtering and clicking February month then also it is showing jan month dates. Please help

Which office do you have dear Teacher

Sir you insert - Check box. How do we get the check box there

Hi, the check box option isnt available on my excel. Can you teach us to put other symbols instead? Like "Yes or No"

@PKAnExcelExpert

Ай бұрын

Yes we can

AT 3:48 what did you click?

Sir, Please one video for the school database in Excel

@PKAnExcelExpert

5 ай бұрын

Will create soon

Hi! I am trying to recreate something similar to this, but instead of the checkbox I am inputting the total hours worked for each employee for each day. However, when I change the month, the hours inputted do not disappear in order for me to put the hours for the new month. How can I add this?

@michaeldingee743

Ай бұрын

I have re-created the report to use hours instead of checkboxes. This report is automated to transfer the monthly data to a sheet called Database. It also has the ability to switch between a full month and weekdays only. The full month shows weekends and holidays. If you wish to have the file, I can email to you.

brother checkbox ko insert tab m kesay add karna h aur ye kam kesay karay ga, m ny is ko insert tab m add kia h lakin hab m kuch cells ko select karta hon aur check box ky button par click karta hon tu check box nai atay in sab cells m

If you select another month or year, is it not suppose to display empty checkboxes? In your lesson it doesn't. It still displays the information of the previous month. Check that out

@michaeldingee743

5 ай бұрын

Insert a worksheet module with this Code, make sure you save as an xlsb filetype. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "G4" Then '

i know it's a repeated question, but i can't find (insert==>Checkbox), even when i downloaded the tutorial sample file, check boxes were (True & false) no check boxes

@PKAnExcelExpert

23 күн бұрын

Check boxes are available in the office 365. You can download our Utility tool to insert the quick check boxes

Sir which Excel version you have ?

@PKAnExcelExpert

Ай бұрын

Office 365

It should ideally not show days of another month. In your example when you selected February it was also showing March 1st and 2nd.

@michaeldingee743

5 ай бұрын

I added a single checkbox in cell AA4 . In cell AM4 FORMULA=DATEVALUE(CONCAT("1",G4,T4)), IN Cell AN4 FORMULA=EDATE(AM4,1)-1 , IN CELL AO4 FORMULA=IF(AA4=TRUE,AQ4,NETWORKDAYS(AM4,AN4)), N CELL AP4 FORMULA =MONTH(AM4), In Cell AQ4 FORMULA =DAYS(AN4,AM4)+1 In Cell D6 which is the Start of a Month FORMULA =SEQUENCE(,$AO$4,AM4,1) If the Checkbox in AA4 is Checked it will give you all days of that month and not show the following month start date. If the Checkbox in AA4 is Un-Checked i will give you Network Days for that month.

@lukekevins1

Ай бұрын

@@michaeldingee743 any idea how to make the next months unchecked? If you check one box in one month it seems to be checked in all months how to make it reset for each month please

I can not insert checkbox in each cells, how is that? thanks the INSERT Tab in my excel doesn't have insert checkbox

@PKAnExcelExpert

8 күн бұрын

It is available in the latest version of Excel. You can use our PK's Utility Tool V3.0 to insert the check box. Visit our website WWW.PK-AnExcelExpert.Com for free download it.

@daddywelknowwell6516

3 күн бұрын

@@PKAnExcelExpert thank you very much

If any one make this chart please share with me

@PKAnExcelExpert

5 ай бұрын

Download link is in the videos description box

kindly replay kar dain

Nice work. Question, is there away to populate another sheet called say "History" and populate this with the Month and Year Data . This sheet data would look something like this. Thanks again. 10001 Shana Li Raj 2024-01-01 TRUE 10001 Shana Li Raj 2024-01-02 FALSE 10001 Shana Li Raj 2024-01-03 TRUE 10001 Shana Li Raj 2024-01-04 FALSE 10001 Shana Li Raj 2024-01-05 TRUE 10001 Shana Li Raj 2024-01-06 FALSE 10001 Shana Li Raj 2024-01-07 TRUE 10001 Shana Li Raj 2024-01-08 FALSE 10001 Shana Li Raj 2024-01-09 TRUE 10001 Shana Li Raj 2024-01-10 FALSE 10001 Shana Li Raj 2024-01-11 TRUE 10001 Shana Li Raj 2024-01-12 FALSE 10001 Shana Li Raj 2024-01-13 TRUE 10001 Shana Li Raj 2024-01-14 FALSE 10001 Shana Li Raj 2024-01-15 TRUE 10001 Shana Li Raj 2024-01-16 FALSE 10001 Shana Li Raj 2024-01-17 TRUE 10001 Shana Li Raj 2024-01-18 FALSE 10001 Shana Li Raj 2024-01-19 TRUE 10001 Shana Li Raj 2024-01-20 FALSE 10001 Shana Li Raj 2024-01-21 TRUE 10001 Shana Li Raj 2024-01-22 FALSE 10001 Shana Li Raj 2024-01-23 TRUE 10001 Shana Li Raj 2024-01-24 FALSE 10001 Shana Li Raj 2024-01-25 TRUE 10001 Shana Li Raj 2024-01-26 FALSE 10001 Shana Li Raj 2024-01-27 TRUE 10001 Shana Li Raj 2024-01-28 FALSE 10001 Shana Li Raj 2024-01-29 TRUE 10001 Shana Li Raj 2024-01-30 FALSE 10001 Shana Li Raj 2024-01-31 TRUE 10002 Sid Laing PK 2024-01-01 TRUE 10002 Sid Laing PK 2024-01-02 FALSE 10002 Sid Laing PK 2024-01-03 TRUE 10002 Sid Laing PK 2024-01-04 FALSE 10002 Sid Laing PK 2024-01-05 TRUE 10002 Sid Laing PK 2024-01-06 FALSE 10002 Sid Laing PK 2024-01-07 TRUE 10002 Sid Laing PK 2024-01-08 FALSE 10002 Sid Laing PK 2024-01-09 TRUE 10002 Sid Laing PK 2024-01-10 FALSE 10002 Sid Laing PK 2024-01-11 TRUE 10002 Sid Laing PK 2024-01-12 FALSE 10002 Sid Laing PK 2024-01-13 TRUE 10002 Sid Laing PK 2024-01-14 FALSE 10002 Sid Laing PK 2024-01-15 TRUE 10002 Sid Laing PK 2024-01-16 FALSE 10002 Sid Laing PK 2024-01-17 TRUE 10002 Sid Laing PK 2024-01-18 FALSE 10002 Sid Laing PK 2024-01-19 TRUE 10002 Sid Laing PK 2024-01-20 FALSE 10002 Sid Laing PK 2024-01-21 TRUE 10002 Sid Laing PK 2024-01-22 FALSE 10002 Sid Laing PK 2024-01-23 TRUE 10002 Sid Laing PK 2024-01-24 FALSE 10002 Sid Laing PK 2024-01-25 TRUE 10002 Sid Laing PK 2024-01-26 FALSE 10002 Sid Laing PK 2024-01-27 TRUE 10002 Sid Laing PK 2024-01-28 FALSE 10002 Sid Laing PK 2024-01-29 TRUE 10002 Sid Laing PK 2024-01-30 FALSE 10002 Sid Laing PK 2024-01-31 TRUE