Forum Discussion
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. ...
pragnya_adi An alternative method would be to use an Excel Table with multiple rows for each person, for each period, and a Slicer to select the period and filter the table. The attached workbooks demonstrate how this could be setup (note: columns A, B and C are grouped/hidden from view... click the [+] symbol in the top margin to expand/unhide them)...
Thanks for it.. These are quite helpful.