I'm not sure if this is possible, but here's what I'm hoping to do:
I have a file (names.xlsx) that has 4 columns - FirstName, LastName, IDNumber, Building
There are 126 rows of data in this file,
I then have another excel file that is a template with all sorts of calculations. I need to fill in the name, ID, and building fields on the template.
I really don't want to have to create 126 copies of the template and then type in the name, id, and building.
I'm hoping that there is a way to have it automatically create a new file based on the template, fill in the 3 fields, and then save the file (ideally with the person's name as the file name and in a folder labeled with the building.
IS THIS AT ALL POSSIBLE??
Bookmarks