Need vb Code

[Ateeb Ali]

Dear Sir
Please see attached file, it has 03 sheets;

Year 2017 Detail: this has all information in detail.
Year 2017 Summary: this is summary report
Example: this is example I need for each supplier

all these separate files should be save in pdf with supplier name as file name and same format data should be available in file as example sheet for each supplier.

Thanks in advance

Regards
Ateeb Ali


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[vletm]

Ateeb Ali
1) Do own folder to this file
2) Save this file to previous folder
3) Do PDF-folder to previous folder
4) Open this file
5) Do not change 'layout'!
6) Use visible see like Your 'source'
7) Press [ Create PDFs ]-button to get Your PDFs

? Questions ?​

 

[vletm]

Ateeb Ali
... and same without Pivot-table,
with something to see,
while run it.

 

[Ateeb Ali]

Thank you so much, this works fine
You are always helpful and great
this forum is such a champ