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
