Forum Discussion
Populate back values entered based on value of a specific cell
To use the same sheet for entering data in any month AND to display the data for any month would be very complicated.
An alternative, but not a very attractive one, would be to create a separate input sheet for each and every month (so a sheet for January 2024, another sheet for February 2024, etc.), and then use the sheet that you already have to display the data for the selected month and year.
Thanks for it.. These are quite helpful.
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)...
