Jul 27 2021 08:08 AM
Hi,
I have a spreadsheet at work with different sheets for each staff member. It has dates of supervisions on - the last date they were done and when they are next due.
To save going through each one all the time to keep track, I'd like to create a front sheet with a summary of all staff and who is overdue etc.
Is there an easy way to do this? To flag the ones overdue etc? please help!
Abby
Jul 28 2021 07:34 AM
Yes it's possible. The INDIRECT function, in particular, comes to mind. Here's a link to a website that offers guidance on how that function works. https://exceljet.net/excel-functions/excel-indirect-function
It would be easiest to help you apply that concept if you could provide a mock-up sample--devoid of any real names of real people--of the way your spreadsheets are laid out.
Other than that, I can offer the attached--which is a totally different situation--but consists of a "Current Summary" sheet that pulls most of its data from subordinate sheets using INDIRECT. So it illustrates the method I have in mind.
Here's what a typical formula looks like: =INDIRECT($D5&"!"&F$1)
If your skill level at Excel is such that you'd like more help, please come back with that aforementioned mock-up example of your own workbook, and I or somebody else can create a working copy for you.