Printing multiple pdf's in excel

[sinha]

Hi Everyone,

This is my first time posting here asking for help.

I have manually update customer details on a excel format which is sales data & then I save them as pdf to be verified & printed to be sent to customers.

I have tried to automate the entire procedure of filling data & printing as pdf automatically by recording but I am stuck at loop & how to save the pdf as customer name.

First tab contains the customer details & on the second tab is the format to update the customer details.

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Item Name[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]1254[/TD]
[TD]Sam John[/TD]
[TD]04-06-2015[/TD]
[TD]Iron25[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]4562[/TD]
[TD]Oliver Cane[/TD]
[TD]03-08-2015[/TD]
[TD]Steel12[/TD]
[TD]1520[/TD]
[/TR]
</tbody>[/TABLE]

Please help me out.

Thanks,
Sinha