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.

ID	Name	Date	Item Name	Amount
1254	Sam John	04-06-2015	Iron25	5000
4562	Oliver Cane	03-08-2015	Steel12	1520

<tbody>
</tbody>

Please help me out.

Thanks,
Sinha