Creating a table that acts as a 'report' from the data above

**LeanneHMUA** · 07-21-2020, 08:04 AM

Hi all

Please see my attached document. The password to open it is russets1 (all confidential data has been removed).

I use this system to track when staff are due their mandatory meeting with their manager. I can see when the date is due, when it is overdue, and when it has been completed and if it hasn't been completed, I can log the reason why.

When my manager says to me: "I need to know who is still overdue their meeting", I need to be able access that information really quickly and easily. Perhaps displayed in a table?

It my not be possible unless I change the spreadsheet somehow?

I'm open to suggestions!!!

Thank you
L

**Bernie Deitrick** · 07-21-2020, 09:44 AM

You have all the information that you need already structured - all you need to do is apply filters in the correct way to show the answer to your question.

I'm not sure what the specific steps are but selecting "No" or "Yes" for the completed column, and using date filters on the supervision columns, I'm sure you can display only those rows that fit your criteria.

Creating a table that acts as a 'report' from the data above

LinkBack

Thread Tools

Rate This Thread

Display

Creating a table that acts as a 'report' from the data above

Re: Creating a table that acts as a 'report' from the data above

Thread Information

Users Browsing this Thread

Similar Threads

Summing categories from multiple table and creating an monthly report

Protected Table acts as normal sheet- VBA useless

Neep Help Creating a Dependent Drop down that also acts as a VLookup to auto-populate

Creating a condition on a report filter in pivot table

Creating a Custom Pivot Table Report Filter

Creating a report from a table

Pull data from a matrix table into a report using 2 report conditions

Bookmarks

Bookmarks

Posting Permissions