Hello All,
I have a requirement wherein i have like 100 records, sample as below. These are stored in an excel spreadsheet.
The target requirement is to send out separate excel spreadsheets to the individual names and ask them to enter the details in columns like Test1, TestB, TestC and so on and send back the emails.
The separate excel spreadsheets that would to the individual users would be like as below:
In addition to that, each excel sheet will have a guideline document (text) in the next tab.
| Guidelines to enter the required missing data | |
| | |
| | |
What should be the best way to achieve this ?