Hello,

I have a work-related project that I was hoping someone could help me this.

In summary, I need 300+ columns to each feed to separate (but exactly the same) questionnaires. We want to pre-populate a few fields before printing them all out to give out to departments.

The solution I have come up with that will work, but mean a huge amount of manual work is:
1. I will start with 1 of the questionnaire and have it reference the separate data table correctly with formulas
2. I will make 300+ copies of the excel file from #1 and go into each one and update the formula very slightly, referencing a different column of data so it pulls the right information for that departments.
3. I will also have to rename all 300 of the excel files to match the right department.

Does anyone know of an easier way?? I think I would need a macro, which I know very little about. The end goal would be for me to not have to go into each separate excel file and update a few letters in each of the fields.

I will attach sample files that show the solution I have right now. Ignore the fact that the addresses are listed twice. Any help or next steps would be appreciated. I probably haven't explained this perfectly.

Questionnaire.xlsxTable.xlsx