Forum Discussion
Xlookups and Templates to Create Report Cards
Hi, I'm very new to this community as well as my current role and I'm wondering if there's a better way to do what I'm doing. I am compiling data from multiple reports and putting them in Excel. ...
There are several ways you can do this. but, I would suggest a macro that cycles the names in a template report card and exports it. This will take a while to run, and your system will be pretty well locked up, but the result will be much faster than doing it manually. And, you will be able to go on lunch while it runs.