Microsoft Forms from Excel Data

[flakedew]

I have the data in excel workbook in sheet named LIST, with particulars of tasks in Column A and Name of Persons in Column D who performs the task mentioned against each row in column A . I need amacro to create a MS Form for each person in column D with the particulars against them in Column A with a provision to select YES / NO or NA for each task and provision to input remarks for each task. Then Save the input data from the forms to a separate sheet within the same Excel workbook and name the sheet as Name of Person found in column D. For each name of person new MS form should be opened to update the data and save the responses in new sheet within the workbook.

 

[igold]

This process would be easier if you created a generic UserForm using the VBA editor and then Insert -> Userform. Add the TextBoxes you think you would like to have.
If after that is done, you could come back here and ask for help as far as triggering and exchanging information between your UserForm and your Worksheet.

Addtionally, any images you could provide of the Worksheet and UserForm would go a long way to getting a workable solution.