Same sheet, many calculations, unique pdf

[Galven]

Hello

I have a sheet including many statistics per client, and I want these stats for each of the 200 clients in ONE pdf file, not 200 files: page 1 = client number 1, page 2 = client number 2, (...), page 200 = client number 200.
To calculate the stats for one client, I juste change the client number in the corresponding cell, no problem for that.

My question is: is it possible to export the same sheet, after each calculation, in a unique PDF File ?

Thanks.

[chinraj]

Hello

My question is: is it possible to export the same sheet, after each calculation, in a unique PDF File ?

Hello, Welcome to the forum!

We can convert the excel sheets to pdf file though VBA/Save As file.

What you meant by after each calculation?

[Galven]

Actually here would be the different steps:

Sheets("Stats").Range("A1").value = ClientNumber1
Application.Calculate
{EXPORT THIS SHEET TO PDF}
Sheets("Stats").Range("A1").value = ClientNumber2
Application.Calculate
{EXPORT THIS SHEET IN THE SAME PDF, but page 2}
Sheets("Stats").Range("A1").value = ClientNumber3
Application.Calculate
{EXPORT THIS SHEET IN THE SAME PDF, but page 3}
...
Sheets("Stats").Range("A1").value = ClientNumber200
Application.Calculate
{EXPORT THIS SHEET IN THE SAME PDF, but page 200}

Maybe it is better like this

[Galven]

Anyone please?