autopopulate data into excel template specific cell and create file for each row

[DanielCarro]

Hi guys,

I need assistance on the following. So I have a list of individuals, each individual has some data which I need to autopopulate into a Excel template which will be for each individual and to be saved as a pdf file.

What I have is the following:

NI Number	Employee No	Company	Full Name	Share Price
111	11A	AAA	AAZZ	10.23
222	22B	BBB	BBVV	25.65
333	33C	CCC	CCWW	36.24

What I need for each individual is the following in the template but one per individual (there isn't duplication)

	NI Number	111	Cell C4
	Employee No	11A	CellC5
	Company	AAA	CellC6
	Full Name	AAZZ	CellC7
	Share Price	10.23	CellC8

Then to save as Filename+Employee No+ Full Name and to be saved as pdf format

So attached is the test data, template and the two expected outputs.

I was trying the following but no success

In the text input I had

Much appreciated any guidance on this one

Kind Regards,

Dan

[RSreeSurya]

Hello,

If you could  share sample pdf with Exact file name and data for reference.

[DanielCarro]

Please find attached pdf

[RSreeSurya · Accepted solution]

Attaching the workflow for the use-case. 

[DanielCarro · Accepted solution]

Hi @RSreeSurya ,

It worked perfectly. 

Many thanks,

Dan

[RSreeSurya]

Hi @DanielCarro,

As it is working, could you please mark my answer as solution for the problem.

Thanks.

[DanielCarro]

Hi @RSreeSurya 

I already accepted as solution

[RSreeSurya]

Thanks @DanielCarro