Advice on Macro to create forms

[C.HELLO]

Hi Everyone,

My apologies if this question has been asked before.
I searched the forum for similar inquiries but was unable to find anything.

My setup:
I have a table in excel with employee name, employee ID, resignation date etc.
The table is fed by various users that use a form made in Microsoft forms.

My task:
After the information is gathered in the excel table, the data must be input into an excel form.
The form is one per employee.

I have created the form in excel and can use vlookup to populate it but this work for one employee at a time.
I would like to automate this and have a macro that creates forms for all employees and saves it as separate excel files in the same folder.

any advice would be appreciated.

 

[Logit]

It is probably just the terms you are using (that are understandable to you), but I'm a bit confused with your description. We can save a ton of time if you would post a sample of your workbook with just enough made up data demonstrating a 'before' and 'after' view of what you are seeking.
Thanks;