Forum Discussion

pragnya_adi's avatar
pragnya_adi
Copper Contributor
Apr 16, 2024

Populate back values entered based on value of a specific cell

I'm creating this attendance tracker in excel.

As you can see that there are entries like a, p for various dates for the month of Jan (B2 cell). These entries are done manually for each date.

What I want is that when I change the B2 cell value to Feb, they should become blank or should populate values previously entered for Feb month.

And likewise when I switch back to Jan, it should populate the above values.

NOTE: In B2 cell, I have created a list from Jan to Dec. And I want to do the same for all months.

  • pragnya_adi 

    You should have a separate sheet that lists the codes for the entire year. You can then use a VLOOKUP or XLOOKUP formula to display the codes on the sheet from your screenshot.

    Microsoft has several attendance tracker templates that do this.

    • pragnya_adi's avatar
      pragnya_adi
      Copper Contributor
      Hi Hans,
      Thanks for the info.
      Since I'm not much aware of it, so could be able to share some code for the VLOOKUP or XLOOKUP formula for this scenario.

      And also if you could share links to few of the attendance tracker templates that would be achieving the scenario that I want to implement.
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        pragnya_adi 

        If you'd like help with your workbook, please attach a copy of it without sensitive information, or make it available on Google Drive, OneDrive, Dropbox or similar.

         

        To find existing templates, select File > New in Excel.

        Type attendance tracker or absence tracker in the search box, then press Enter.

         

Resources