ExcelBanter - Creating Multiple Scorecards/Files and Compiling data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Creating Multiple Scorecards/Files and Compiling data (https://www.excelbanter.com/excel-programming/349816-creating-multiple-scorecards-files-compiling-data.html)

Consulting Joan[_2_]

Creating Multiple Scorecards/Files and Compiling data

I have a scorecard template which I need to populate with about 300 people -
name, title, salary, etc - and create individual files to distribute. Then I
need to collect these files and compile them.

This has been a manual process using Excel. Any suggestions on how to
"automate" within Excel?

All times are GMT +1. The time now is 05:33 PM.