Forum Discussion
How to auto populate a table based on name and date?
brochelle How important is the report template? If you have free hands to create something better, consider using a Pivot Table. A powerful, built-in, tool that requires a minimum of preparation. And fairly easy to learn. Are you familiar with pivot tables?
The data appears to be perfectly organised. Added two calculated columns and with a few tweaks, you can create a report like in the attached file. Add data at the bottom of the table. Press Refresh All on the Data ribbon and the report gets updated instantly. Not exactly the same as what you produce now, but similar and fully automatic.
The template is not super important, just what the managers are used to. This is great though! I just got a request from a manager needing performance reports on all of their location's employees and this pivot table will be great for showing a mass number of employees! I assume I could just create a slice for that pivot to show between 2 specific dates, right? This will be super helpful! Thank you!
Also, the solution I found for the current template is I just use an xlookup using 2 search params(combined using '&' I didn't even know this was possible). It gets the job done, just fairly slow.