I need help in PDF Generation for multiple name with calculating their total expense

[lijofrancis333]

My table in excel is as below:

id name expense value
1 a e1 10
1 a e1 20
2 b e1 15
2 b e2 20

I need to create a pdf saying " Dear Mr. a, your expenses on e1 is 30 & the total expense is the sum of 30" and save it as 1.pdf (id.pdf)
and another pdf saying " Dear Mr.b, your expense on e1 is 15 & e2 is 20 & the total expense is the sum of 35" and save it as 2.pdf(id)

[Pepe Le Mokko]

Hi and welcome

Some suggestions you may fund useful:

1. Our answerers are looking to "help" more often than they are looking to "do an entire project for you for free".
2. Jump into this project yourself, when you get stuck on ONE specific hurdle, post that ONE item as a forum question.
3. Show us what you've tried in an attached sample workbook and how it's not working for you. When you're doing the work yourself, just writing out a complete example question in a forum often points you to solution before you even finish posting.
4. If you can't make any headway at all and no help is forthcoming in the free forum(s), we do have a Commercial Services forum where you can pay for assistance directly from our EF gurus."

[lijofrancis333]

Hi,

Actually I need help in developing this logic in excel VBA.

Thanks

Lijo