Making a Attendance sheet entry dynamic

shows us your excelfile you already made.

I have uploaded the screenshot.

I can't open the screenshot.
And I asked for a excel file we can't do anything with a screenshot, this isn't a photoshop forum

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Thank you for your help.

I am attaching my excel workbook book with this post.

Just to ensure my understanding of how the workbook is to be used- you want to enter a 1 or 0 in the Master sheet to indicate 'Present' or 'Absent'. Then these are to be saved somewhere (please indicate where?). If the month or year is changed at the top of that sheet, any saved data for the new month / year is then to be displayed for each employee- is that the basic idea?

How do you plan to layout the Database worksheet- for example, attached image 1 shows one possible approach and image 2 shows another layout. The layout has implications for any coding. If you've attempted some coding, you should also upload same.

Here's a VERY rough workbook. You'll likely need to modify it to make it more flexible but maybe you have enough here t see what changes are required.

There's a 'Save data' button on the Master sheet. When you've added attendance data for a time period, click it and the result are saved on the 'Saved data' sheet.
If you change the month or year on the Master sheet, any existing data for the new month and year is copied from the 'Saved data' sheet to the Master sheet.

The data validation was wrong for the years- fixed in attached. I also updated the code to clear cell content when the month or year is changed.

Are you using the correct language for the names of the months?

It definitely works on the copy uploaded in post #13

Two possible fixes:

1. Do you enable macros when the workbook opens? You might see a yellow bar just beneath the ribbon which says something like 'Enable content'. That needs to be done for the data to be updated because the whole process is driven by macros.

2. You might also need to 'unblock' the Excel workbook (a Microsoft security measure for macro enabled workbooks downloaded from the web)- to unblock the workbook, go to your "Downloads" folder > right click on the file > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.

The formulas in cells E7:J7 must be :

Please Login or Register  to view this content.

I changed the month names in month numbers
Do you get now the same error?

Do you have any errors in the 'Helper' tab?

its working fi9 to me Some functions and features may vary between different versions of Excel. Make sure the function or feature you're using is supported in your version of Excel.

please find the screenshot
Attachment 853240